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

Import Data using DTS Expand / Collapse
Author
Message
Posted Tuesday, June 12, 2012 7:03 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 9:20 AM
Points: 51, Visits: 134
I have a DTS package that imports the data from csv file into the table everyday. I Now the import filename is different (with datetimestamp) every day.
Two questions:
1. I am trying to use global variable to create a file name dynamically but somehow not able to use it into the import process.
2. I have added one extra column into the destination table, I want to have a import filename into it so that I can track which row is from which file.
How to do this?

Thank you
Post #1314406
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse