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. http://msdn.microsoft.com/library/en-us/dtssql/dts_usage_7703.asp and BOoks online is your best bet. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>