Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Changing ext. config values on deployed package

Author  Topic 

qman
Constraint Violating Yak Guru

442 Posts

Posted - 2014-06-06 : 13:44:28
I have a package that utilizes an external config file. This config file contains a single data parameter.

My package recognizes the value set in the config file during runtime from within Visual Studio (GOOD!).

Once deployed to SQL Server, how can I change the parameter from within "Execute Package Utility" via SQL Server Studio/SSIS to some other date?

I have tried pointing to an additional config file under "Configurations". The value in this file never gets referenced.

Thoughts...?
   

- Advertisement -