Executing packages in a specific sequence

  • I am facing some issues while working on SSIS in VS2005,

    The Scenario is we have 35 excel files from which we have to import data

    to Sql 2005.

    We have to execute these packages in a specific sequence so we are not

    using For Each Loop Control.

    Now the Problem is this that we have 35 executables as an output that is

    corresponding to each package, and from each executable we can Change

    excel path and Sql Connection String.

    The problem is that one has to open each executable to set the path; we

    wanted to keep them Configurable like , as if we can have any variable

    define in the packages for path, and in the packages we use that variable

    and append the XLS file name to it like ..

    @PathVariable+ test.xls

    And from the Configuration file at run time we can set the path to this

    variable like

    @Path Variable="C: /Windows/ Test Folder/"

    And then executable picks the path from there.

    Is there any possibility to implement any thing similar, we have tried but

    its not working, any help in this regard will be really appreciating.

    Its really urgent, I will wait for feedback on this.

  • You can define an Excel connection manager in your package. Point it to an existing spreadsheet. Go into the Excel Connection manager properties. Then into expressions. Find the ConnectionString property and open the expression box for that property. Open the variables list and drag your variable into the expression window. You can test the expression to make sure it looks right. You can then enable package configurations and select the value for your variable. It will then show up in your config file.

     

    Hope this helps!

    MarkA          

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

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