Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Picking up files in a directory
Message
De
19/08/2011 07:45:29
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Picking up files in a directory
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01521327
Message ID:
01521327
Vues:
90
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform