SQL Server Performance Forum – Threads Archive

DTS load text file

Hi I need to create a DTS package that imports a text file each day. The problem I have is the file has a date stamp on it so the file name changes each day. The filename starts ussdyyyymmdd.txt (ussd20070419.txt tomorrow it would be ussd20070420.txt) How can I get the DTS package to pick the file up each day ?

http://www.databasejournal.com/features/mssql/article.php/3325731
http://groups.google.co.uk/group/mi… file to import&rnum=2&hl=en#dcb6c380219d1af4 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

You can also use BCP and OPENROWSET…. The following is the example is sql to text file but you can use the sample to do opposite… http://sqljunkies.com/WebLog/madhivanan/archive/2005/10/26/17217.aspx
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>