|
Posted by gelangov on 08/21/07 15:38
I have 2 variables, one is the column name of the table and the other
one is the table name and I need to write this in the "Execute SQL
task" of a "For each loop" container in a ssis package like this:
Truncate table <tableName>
Insert into <tableName>
Exec (' select [' + ?+ '] from '+ ?)
It gives me error message when I try run the ssis. However if I put
the above statements into a stored procedure and wrote look this, it
works:
spStroedproc ?, ?
Do I need to change any of my settings for my "Exec" to work?
Thank you in advance
Navigation:
[Reply to this message]
|