Dear friends, i need some help about a DTS i've been creating. I wanna read a SQL sentence from a table and put it into my DTS global variable. Then execute this DTS global variable to obtain a result set. How can i do that ? Thank you.
http://msdn2.microsoft.com/en-us/library/aa933470(SQL.80).aspx http://www.sqldts.com/205.aspx http://www.databasejournal.com/features/mssql/article.php/1461581
Hi, I feel it would be better if you create a stored procedure to read SQL statement from table and then execute the same in the stored procedure itself and return the result. Still if your case requires you to create DTS/SSIS package then create it by adding SQL execute task and call the above stored procedure and capture the result in resultset present in SSIS package.
Thank's friends for reply. Yes, my enterprise have best practice about ETL process and i need use DTS techniks. I think that i can pass my global variable (with a SQL sentence readed from a table) to a store procedure and then execute my SQL sentence in it (using Execute SQL Task icon). Thanks!