Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Filesystemobject in SQL server2000 DTS

Author  Topic  pad Starting Member 2 Posts Posted - 2007-08-29 : 14:58:21 Need help to code for processing one or more files in an order by the name of the file. example of file names Fileone --20070824test.csv File two ---20070825test.csv file three ---20070826test.csv. out of the three files the dts package should pick fileone and process,then pick file two and finally file three(the processing order should be as said above) i have the code to process in any order but iam not able to make it as above.