SQL Server Performance

DTS Sql Server 2005

Discussion in 'SQL Server 2005 Integration Services' started by carrascojg, Apr 9, 2008.

  1. carrascojg New Member

    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.
  2. MohammedU New Member

  3. ranjitjain New Member

    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.
  4. carrascojg New Member

    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!

Share This Page