USE This

Select * From information_Schema.Columns

Where Table_Name like '%tblPopulation%'

1st verify that table exists or not. If its exists check which Schema its using.

Hope it helps

there are a lot of FOREACH Loop for SSIS :

This one will give you a head start.

http://www.select-sql.com/mssql/loop-through-ado-recordset-in-ssis.html

hope it helps.

Glad to help.

yeah i really hurt when you use it in a view. Its a nightmare :hehe:

Jeff, Actually OP is using (*) when in the select statement something like this

Select IDENTITY(INT,1,1) AS RowID, *

into SomeTable

From Table

When we use this as the rule of thumb, identity column...

you are facing this Issue because of (*). when you do the following :

SELECT * INTO TABLE2 FROM TABLE1.

and an identity column exists in it, that particular identity column will...

Try THIS[/url]

when you say 100 tables how exactly have you running your...

Nice question, thanks for sharing

+1

+1 Jeff,

By the way, did your boss shared any information when he asked for this table. He might have shared something didn't he?

Glad to help.

Check this

:hehe:

please share that execution plan.