Post reply

SSIS file import

  • September 18, 2012 at 6:48 am

    #281901

    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.

  • September 18, 2012 at 6:55 am

    #1539066

    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

  • September 18, 2012 at 7:12 am

    #1539076

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

  • September 18, 2012 at 7:46 am

    #1539100

    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?

  • September 18, 2012 at 7:52 am

    #1539106

    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.

  • September 19, 2012 at 12:47 am

    #1539399

    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