SQL Server Performance

DTS load text file

Discussion in 'SQL Server DTS-Related Questions' started by mlucas, Apr 19, 2007.

  1. mlucas New Member

    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 ?
  2. satya Moderator

  3. MohammedU New Member

Share This Page