Posted by Erland Sommarskog on 08/22/07 21:40

(gelangov@hotmail.com) writes:
> I think I did not write it clearly...May be I should have written it
> like this:
> Truncate table table1
> Insert into table1
> Exec (' select [' + ?+ '] from '+ ?)
>
> The "?" are where the variables are. It works fine in the query
> analyzer (of course, after changing the question mark to variable
> names).
>
> My question is:
> Are there any settings I need to change in order for "Exec" to work in
> SSIS?

I can't answer any questions about SSIS per se, since I don't know SSIS. But
I believe that SSIS is essentially just another client application as far as
the engine, and since I know the engine and some client programming, I
might be able to provide some guessworks if you post the SSIS code
where you invoke the batch above.

Of course, asking the friendly people in microsoft.public.sqlserver.dts
may also be a good idea - they are likely to produce more than guessworks.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]