Post reply

dynamic filename in SSIS flat file source

  • September 18, 2013 at 2:14 pm

    #278032

    How to specify for dynamic filename in SSIS flat file source

    for file 20110818_abc_def.csv

    as the name abc_def does not changes only the date part changes. so how to make it dynamicaly and also the file source location does not change.

    Any clue on it.

    Shaun.

  • September 18, 2013 at 2:21 pm

    #1651292

    http://www.mssqltips.com/sqlservertip/1084/dynamic-flat-file-connections-in-sql-server-integration-services/

    Try this and let us know if you run into any issues.

  • September 19, 2013 at 9:28 am

    #1651565

    can i send an e-mail with the issue. I do have a packaage alaready existed but it has to be done for 2 more files but name changes.. so i'm getting lost in it.. As the files will be generated to the same location but those 2 files addition to it..

  • September 19, 2013 at 9:52 am

    #1651577

    The for-each look is your friend, along with some variable manipulation.

  • September 19, 2013 at 9:52 am

    #1651578

    i am geting lost no idea how to do it.. im new in it..

  • September 19, 2013 at 3:17 pm

    #1651685

    Shaun2012 (9/19/2013)

    i am geting lost no idea how to do it.. im new in it..

    The article suggested by Chrissy321 should walk you through how to do a dynamic expression for a flat file connection. It's got the steps to set one up pretty clearly described. Your package will end up with a connection set up in much the same way. If you have multiple files, set up the connection first (see the article) and then you can move on to the for/each loop suggested by Manic Star.

    So start with the suggestions you've already gotten, particularly the article. If you have specific issues as you try to do that, let us know what you've tried and what you're having difficulty with.

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

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