SQL Server Performance Forum – Threads Archive

Dynamic file names in DTS

I have a DTS package that transfers data from a text file to a table.
The text file however has yymmdd appended to it’s name eg. abc041029.txt. How can I set up the package such that the connection to the text file dynamically takes today’s file. Thanks in advance.

http://www.databasejournal.com/features/mssql/article.php/1462571 andhttp://www.sqldts.com to accomplish your task. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks for the link Satya. I ended up using Dynamic Properties Task for quick implementation and found one other good one with step by step instructions. http://databasejournal.com/features/mssql/article.php/3073161

]]>