Post reply

Dynamically accessing the folders and excel files

  • December 22, 2008 at 5:45 am

    #216855

    Hi,

    In SSIS 2005

    1. I would like to access the files from a dynamic path

    2. Access the excel files from that dynamic path.

    how to achieve?

    any help, links would be greatly appreciated.

    Thanks,

    Regards

    Viji

  • December 22, 2008 at 7:12 am

    #916132

    You can setup the file connection managers connection dynamically using expressions. You can also use variables to help you out if needed if you need to loop through the directory to retrieve a dataset of the objects and then shred the dataset to get and set variables that you can then use in your expression to connect to the files.

    I would highly recommend heading out to Jamie Thomson's site for any type of reference for SSIS and code examples - http://blogs.conchango.com/jamiethomson/[/url]

    Here are a couple of links that might help you out in setting up your package, but he has plenty more where these came from:

    SSIS: Expressions on ForEach enumerators

    SSIS Nugget: Execute SQL Task into an object variable - Shred it with a Foreach loop

    Use variables and set the connection manager connection to an expression based on your variable name retrieved from the recordset of file names.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

Viewing 2 posts - 1 through 1 (of 1 total)

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