July 28, 2013 at 11:54 pm
The Scenario is that I am deploying the SSIS packages from test network to production server. The architecture of my SSIS packages are that for each table I am having one package which pulls data from the oracle application and dumps to the sql server.
so for 20 tables I am having 20 packages. On top of these 20 packages I am having a master package which calls these 20 packages. I have enabled the package configuration for these 20 packages and is using XML configurations for creating the Config file. And then I am reusing the Config file in all the corresponding packages.
Then I deployed the packages and did file system installation lets say in C drive deploye folder. so c:/deploy will now have the config file along with all the packages.
Now we I changed the datasource in the config file and running each packages individually then they are referring the Config file from c:/deploy. But when I am running the master package then it is referring the Config file fro the Bin folder.
How can I configure the package such that the master package also refers the Config file fro c:/deploy folder. I cannot use environment variable on production server.
Thanks
Rahul Sahay
July 29, 2013 at 2:01 am
You could try to work with relative paths:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 30, 2013 at 2:11 am
Setting up a SQL Agent job to run the master SSIS package may help. The job step configuration for an SSIS package includes a "Configurations" tab for defining which config file(s) to use.
Forum Etiquette: How to post data/code on a forum to get the best helpMake sure that you include code in the appropriate IFCode tags, e.g. <your code here>. You can find the IFCode tags under the INSERT options when you are writing a post.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply