SSIS file import

  • Hi,

    I would like to build a package that imports a file from a file server on a daily basis. the file is a .txt file and is saved as "Filename_20120102.txt", when importing this file I would like my package to ignore the date and just pickup the file using the file name.

    Please assist.

  • I'd just use a For Each File Loop with Filename*.txt as its filter.

    There's a tutorial here - it was written for 2005, but the process is the same for 2008

  • Thanks Howard, i'm on it will let you know how it goes

  • Hi Howard,

    I tried it but my enumerator configuration is empty. could it be because I don't hav a full version of visual studio installed?

  • I think it's a UI bug. You have to drop down the Enumerator Selection and re-select "Foreach File Enumerator" and the options will appear.

  • Hi Howard,

    Thanks, I got it right now and I managed to import the files.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply