Post reply

DTS for multiple files in a directory

  • July 8, 2005 at 5:10 pm

    #167451

    We created a package using the DTS designer (under Sql 2000). The only problem is that we want to run this package for every file found in a directory. And  the DTS package uses a fixed name for our source input file.  Any ideas how to get around this problem much appreciated.

    TIA,

    Bill

  • July 8, 2005 at 5:25 pm

    #572660

    Here is one way to do it:

    http://www.sqldts.com/default.aspx?246

    Another way is the way I've done it in my last job.  Create a parent package, create a ActiveX script to loop through the files in the folder and call the child package(the one you have already) and pass the file name in as a global variable.

    Good Luck!

    Diane

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply