Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to import selected file with a saved DTS package Expand / Collapse
Author
Message
Posted Wednesday, February 03, 2010 2:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, February 03, 2010 9:09 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 4,056, Visits: 5,182
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 »

Add to briefcase

Permissions Expand / Collapse