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
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Using DTS to copy a daily csv file

Author  Topic 

jgabrielson
Starting Member

1 Post

Posted - 2006-08-10 : 15:25:50
Hey,

I have a computer that creates a daily cvs file of data. each file has a date in it: Test-s-08102006.csv and so for. I want to create a DTS package that will find the daily file and transfer the file. I have been able to create a package that will pick out one certian file and bring over the data once a day, but I need to be able to pick out the daily file, or even create something that will merge the daily excel file into one so then I can take that file through DTS. Any thoughts or suggestions on this? I have been scatching my head on this one.

Thanks

Josh
   

- Advertisement -