DTS Structure Help
Posted on 2006-06-05
i am new when it comes to DTS in SQL Server. I want to do the Following.
Generate a Text File on weekly bases from a SQL Server 2000 DB.
after File is been generated i want to store the ID number of Each row(that was inserted into a text file) into another table (such as a Log Table).
So i know the first Step. Like
Data Source (SQL Server Table) ----------> Text File (Destination)
This works fine, generates the Text file, but then how do i Execute a SQL Query to insert Records into a Table(storing whatever was inserted into the Text File).
I mean how do we define steps, i am so confused about defining Steps in DTS Like from here to There and there to execute a batch or what so ever.