All geek questions in one place

SSIS 2008 R2 - Dynamically Changing Runtime Connections

I am using SQL Server SSIS 2008 R2.

I want to dynamically change the connection manager for OLEDB at runtime to point to the database defined at runtime.

This means that I cannot use configuration files.

How can i do this?

+3
source share
2 answers

You must use expressions and populate the variable with the connection property that you would like to change. The properties of each object have a field called expressions that you can open and dynamically change.

+7
source

Use expressions in connection manager properties windows to create a value at runtime

http://consultingblogs.emc.com/jamiethomson/archive/2006/03/11/SSIS-Nugget_3A00_-Setting-expressions.aspx

+5

Source: https://habr.com/ru/post/1792640/

More articles:


All Articles