Connection string from outside

Hi there!!

I want to make a package and pass connection string from outside say through .ini file, so that I can put package on any system and use some external source to pass connection string.

How do we do this in SSIS?

Rahul Kumar, Software Engineer, India

Hi,

Package Configurations in SSIS are used for the same purpose that you are looking for. Package config can be used to pass on the values to the package at run time. For more details, please check http://msdn2.microsoft.com/en-us/library/ms141682.aspx

Let me know if this solves your issue.

Thanks,

S Suresh

|||

Hi Suresh

Yeah this is fine,we can assign configuration settings but still I am scratching my head how to change connection string in connection manager

|||

If you define a configuration, this is held as part of the package definition. In yoru case you would define the configuration such that the property value to be set is the ConnectionString of the specified connection.

When the package loads the config is processed, so your new connection string is read for the specified location and applied. That loaded instance of the package will have the new connection string on the connection manager.

Still got an itch? If so can you explain why you do not think thsi solves the issue?

|||When you go through the Package Configurations Wizard choose the ConnectionString property of the ConnectionManager you want to configure. At runtime it will try and configure that property for you. You don't have to manually set it.