Connect to XML configuration file using C#
Hi
I am on SSIS 2008 and I created 2 XML configuration files with OLEDB connection name 'ServerConnections' on the package and I need to use C# to call it. follow by I placed these 2 XML configuration files on A and B SSIS servers on their local E:\Conn folder and in the config files XML Data source I have confgured the A SISIS server to Development SQL server and B SISS server to production SQL server. On my work station the package that I have using the Script Task I tried to execute a store procedure but how can I call the XML configuration file with the OLEDB package connection string 'ServerConnections' using C#? Any ideas? Thanks.
|