March 30, 2012 at 7:19 am
Hi All
As I'm going to be doing end to end environment testing on a number of packages, I have created 4 XML configuration files, which change the default values of variables and the servername of the connection managers.
I have enabled the create deployment utility and built the solution, now when I double click the manifest it runs through the process as expected, shows me the configurations if I want to edit them, then does the deployment.
Now when I go into SQL Agent and do new job and get the package, the configurations tab is empty, its not uploaded any files. Have I missed something or do I need to manually upload the dtsConfig file after the deployment of the SSIS package?
Secondly when it comes to live deployment it will be put on a cluster and stored in MSDB, do the config files also get loaded into MSDB by the manifest or adding it manually or does it live on the file system? Just so I know if I need to put it on a clustered drive or not?
I'm a newb when it comes to configurations, any help is appreciated.
Thanks
March 30, 2012 at 7:49 am
Hi Anthony
Just a thought as I have only worked with XML configuration files a couple of times but have you tried using the SQL config tables instead of XML to see if you have the same problem?
In addition I also find these easier to work with as to make changes you don't have to go trawling through XML...
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply