May 16, 2008 at 3:53 am
How do I export the connection manager properties to an external file such as a xml file.
Regards,
Ben
May 16, 2008 at 5:59 am
I'm not sure what you are asking for here? Are you looking to view the connection properties for a given SSIS package in XML format, or are you looking to have an external XML file for each connection that you can change when moving to different environments?
If you are just lookingto view them, you can view the .dtsx file in any XML reader including Internet Explorer. If you are looking to store these connections (or portions of them such as server names) externally in XML configuration files, you need to do this in the package configurations section of each package you are working with. Search "Package configurations" in books on line for details on how to do this.
May 20, 2008 at 8:27 am
Are you looking to make a Configuration File where you can edit the server connections? Try this article: http://www.sqlis.com/26.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply