How to import selected file with a saved DTS package

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » How to import selected file with a saved DTS...

How to import selected file with a saved DTS package

Rate Topic

Display Mode

Topic Options

Author

Message

SPAREUS

Posted Wednesday, February 03, 2010 2:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 14, 2010 1:50 AM
Points: 4, Visits: 11

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.

Post #858476

Greg Charles

Posted Wednesday, February 03, 2010 9:09 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:14 AM
Points: 4,006, Visits: 4,850

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

Post #858792

« Prev Topic | Next Topic »

Permissions