DTS: Import data from file

DTS: Import data from file

 

  

I am trying to import data from text file to a SQL
table.
The files come in daily and have format
FileNameMMDDYYYY.txt

Can someone help me design DTS package that can take
in cariable file names?

Thanks!




__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

MS Sql Server LazyDBA home page