Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Config File Package Configuration Expand / Collapse
Author
Message
Posted Sunday, July 28, 2013 11:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:28 AM
Points: 16, Visits: 113
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
Post #1478445
Posted Monday, July 29, 2013 2:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:52 PM
Points: 13,636, Visits: 11,509
You could try to work with relative paths:

Relative Paths in SSIS




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1478462
Posted Tuesday, July 30, 2013 2:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 11, 2014 4:18 AM
Points: 157, Visits: 204
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.
Post #1478872
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse