Menu
Is there a quick way to determine where within a package a connection is used?
684
Configure at design time.In SSIS Designer, double-click on your OLEDB connection manager to open the Connection Manager window. In the Provider drop-down list, select Microsoft OLEDB Driver for SQL Server.
Retain Same Connection is a property setting found on connection managers. By default this property is set to false which means that each time the connection manager is used the connection is opened and subsequently closed.
For example, a connection manager includes the ConnectionString property that you set at design time; at run time, a physical connection is created using the value in the connection string property. A package can use multiple instances of a connection manager type, and you can set the properties on each instance.
To access the connection manager, go to https:// hostname : port /optim/admin/, where hostname and port are the host name and port of the application server. If you install the connection manager with WebSphere Application Server Community Edition, then the default port is 8443.
within visual studio you can search for all instances of the connection string with ctrl+shift+f
144
I usual right click on the package and look through the XML code
3
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
