MS SQL Server DTS - Altering a Connection Manager Dynamically via Variables

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Altering a Connection Manager Dynamically via Variables

RQGal

2006-03-29, 11:29 am

Within an SSIS Package, we are trying to change the connection string
of an output file connection manager at runtime (used for package
logging).

To do this, we have defined variables with package-level scope and set
the connection manager connection string to this variable. The first
step of the package is to set these variables. The second step begins
the rest of the package operations (moving data). The package executes
successfully, but the log file is never created/appended to.

When the package is debugged, I can verify that the variables are being
set correctly in the script task and that the variable values are being
passed to the connection manager data sources.

Any ideas why this isn't working?

Sponsored Links