Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Picking up files in a directory
Message
From
19/08/2011 07:45:29
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Picking up files in a directory
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01521327
Message ID:
01521327
Views:
89
Hi

I've created a dtsx package to import a csv file.

The import filename is effectively hard coded into the dtsx package.

How can I make the package pick the oldest file in a folder.

the folder is where incoming csv files will be placed and I want a job to be picking up the files from that folder and processing them before moving the file to a backup location.

Any tips or ideas are welcome

Thanks

Nick
Next
Reply
Map
View

Click here to load this message in the networking platform