How to package Stored procedures to DTS task?
Posted on 2006-05-25
I am creating a new DTS package that will process the data movement.
the workflow is like this:
FTP download *.zip file to c:\data\FtP_Download --> uzipping *.zip files --> create new folder and copy all *unzipped files to the new folder.
For the first part, I created a SQLDTS FTP Task to handle it, and it works fine, for the second part and third part I have created two Store Procedures to take care of these.
Now I am trying to create a new DTS package to make workflow. I used Execute package task to load FTP task, now how can I put the stored procedures to make the task flow. I try to use "Execute SQL task" to package stored procedures, DTS editor said " to define this task, you must define at least one connection". My question is which connection I should chose? becasue those *.zip will all loaded in to my c:\data\ftp_download anyway. Any idea?