Data driven query task | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Data driven query task

Hi Can i write multiple queries (i.e. insert as well as update) in a single "Data Driven Query Task" box using DTS?
please let me know if that is possible. regards, chetan

The Data Driven Query task allows you to perform flexible, Transact-SQL based operations on data, including stored procedures and INSERT, UPDATE or DELETE statements. For each row in a source rowset, the Data Driven Query task selects, customizes, and executes one of several SQL statements. and BOoks online is your best bet. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.