How to package Stored procedures to DTS task?

Posted on 2006-05-25
Last Modified: 2012-06-22

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?

Question by:LIULIHUA
    LVL 20

    Expert Comment

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

    It should be the connection to the database where your stored procedures are.
    LVL 30

    Accepted Solution

    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

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now