Hi, could someone tell me how I go about creating a DTS package that executes two stored procedures and have the results put in 2 different files which are stored on a remote location (another server)? I have never worked with DTS packages before and would really appreciate the help. Thanks in advance
new package from sql to destination 1 text file (path it like \\192.168.1.1\d$\folder\file.txt) use query, put in exec sp_xxxxx chose options for pipes, tabs, commas, etc save do the same thing for the other file now you have 2 dts's create a 3rd dts, which calls these two packages inset the connection object insert the two package tasks click on the first, then ctrl click the 2nd, right click, On success draws the arrow for you. save and close then you can schedule the main "wrapper" package to run it all at once nice and easy