Data Sources + SSIS Package Configuration File, just want to make sure of something ...
-
martes, 09 de noviembre de 2010 7:02
Hi,
I have a solution with say 10 SSIS packages.
I have 2 data source connections defined.
I added connection managers to all of the 10 SSIS packages - based on these 2 data source connections.
Then I created a configuration file which I 'reference' from each of the packages, the configuration file contains a connection string for the connection managers.
However when I open an SSIS package in the solution (if the configuration file contains a different connection string) it tells me that the connection string is different and will be overwritten with what is currently defined in the data source.
Is this correct?
When I one day schedule SQL jobs for these SSIS packages - that reference specific configuration file - will they use the connection strings defined in the configuration file?
thanks,
Ian
(i will test it soon - but don't want any unexpected behaviour)
I.W Coetzer
Respuestas
-
martes, 09 de noviembre de 2010 9:18 If configured Connection Managers to use UDL file to make the connection in your Package Project then they will work under that configuration. It worked for me.
Willy Taveras.-
http://itlearn.net- Marcado como respuesta I.W Coetzer jueves, 11 de noviembre de 2010 20:34
-
martes, 09 de noviembre de 2010 9:42Moderador
If you have package configurations enabled and you have selected the relevant configuraiton file, the package should pick up the connection strings from the file not those stored locally. You can also pass a configuration file to the package at runtime using the /CONFIG switch.
There is lots of documentation on config files on the msdn pages.
http://msdn.microsoft.com/en-us/library/cc895212.aspx
http://msdn.microsoft.com/en-us/library/ms166598.aspx
every day is a school day- Marcado como respuesta I.W Coetzer jueves, 11 de noviembre de 2010 20:34
Todas las respuestas
-
martes, 09 de noviembre de 2010 9:18 If configured Connection Managers to use UDL file to make the connection in your Package Project then they will work under that configuration. It worked for me.
Willy Taveras.-
http://itlearn.net- Marcado como respuesta I.W Coetzer jueves, 11 de noviembre de 2010 20:34
-
martes, 09 de noviembre de 2010 9:42Moderador
If you have package configurations enabled and you have selected the relevant configuraiton file, the package should pick up the connection strings from the file not those stored locally. You can also pass a configuration file to the package at runtime using the /CONFIG switch.
There is lots of documentation on config files on the msdn pages.
http://msdn.microsoft.com/en-us/library/cc895212.aspx
http://msdn.microsoft.com/en-us/library/ms166598.aspx
every day is a school day- Marcado como respuesta I.W Coetzer jueves, 11 de noviembre de 2010 20:34
.png){kind=spacer}
