Post reply

How to import selected file with a saved DTS package

  • February 3, 2010 at 2:57 am

    #74212

    Using SQL 2000.

    I have SQL 2000.

    I have saved a DTS package for importing data from text files.

    Problem is that DTS package always refer to the same file.

    Is there a way so that when I run the package, it will ask me to choose a file to import?

    Regards,

    Spareus.

  • February 3, 2010 at 9:09 am

    #1112996

    You can create a global variable in the package to hold the file name/path and use it to set the text file connection. Here's a link to some sample ActiveX script tasks;check Tasks and Connections in the FAQ: http://www.sqldts.com/

    Greg

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

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