On Apr 4, 1:19 pm, Allan Mitchell <a...@no-spam.sqldts.com> wrote:
> Hello Dinsdale,
>
> Why not use a DataFlow to query sys.tables to get the names of the tables
> into a Recordset destination(or even an ExecuteSQL task into an Object variable)
> and then iterate over that instead.
>
> --
>
> Allan Mitchellhttp://wiki.sqlis.com|http://www.sqlis.com|http://www.sqldts.com|http://www.konesans.com
>
> > The end result of what I am trying to accoplish is this: I would like
> > to use SSIS to reset the identity fields on all tables where the table
> > name ends with _type. If someone has a better suggestion than what I
> > am currently trying, please feel free to suggest it. That said:
>
> > I am trying to use the Foreach ADO.Net Schema Rowset loop to iterate
> > through the tables in the database and then extract the table_name
> > parameter to use in an SQL query (DBCC CHECKIDENT). I would like to
> > limit the tables that the foreach loop iterates through using the
> > collection restrictions. I cannot seem to find a way to use a wild
> > card to limit the recordset to tables where the table_name parameter
> > value ends in "type". I have tried to use a wildcard (%,*,&) in the
> > text field with no success. I am not sure how I would use a variable
> > or even build an expression that would accomplish this.
>
> > So I guess my question is how to use wildcard values in the
> > restrictions field to limit the tables retrieved by table name?
>
> > Thanks in advance.

> The end result of what I am trying to accoplish is this: I would like
> to use SSIS to reset the identity fields on all tables where the table
> name ends with _type. If someone has a better suggestion than what I
> am currently trying, please feel free to suggest it. That said:
>
> I am trying to use the Foreach ADO.Net Schema Rowset loop to iterate
> through the tables in the database and then extract the table_name
> parameter to use in an SQL query (DBCC CHECKIDENT). I would like to
> limit the tables that the foreach loop iterates through using the
> collection restrictions. I cannot seem to find a way to use a wild
> card to limit the recordset to tables where the table_name parameter
> value ends in "type". I have tried to use a wildcard (%,*,&) in the
> text field with no success. I am not sure how I would use a variable
> or even build an expression that would accomplish this.
>
> So I guess my question is how to use wildcard values in the
> restrictions field to limit the tables retrieved by table name?
>
> Thanks in advance.
>