Dynamic file names in DTS | SQL Server Performance Forums

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
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