• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

How to package Stored procedures to DTS task?


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?

1 Solution
>>My question is which connection I should chose?  <<

It should be the connection to the database where your stored procedures are.
As sirees said you'll need to define a connection first - drop it on the page and define the connection to the database where yuor stored procedures are.

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now