October 9, 2006 at 9:44 pm
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.
October 11, 2006 at 5:59 am
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