Hi,
I need to configure my package using SSIS Configurations. When I opened SSIS Configuration wizard, press ADD and selected Xml Configuration, I found two options.
One being : Specify configurations directly.
next : config location is stored in env variable.
How to use the second option?[ env variable]. Say I want to configure my connection string for my destination database [ OLEDB Destination Component]. How to do that using second option.
Thanks
Kishan
You first need to create your configuration file so go for option 1.
Once you've created it, create an environment variable whose value is the path and filename of the config file.
Go back into your configuration and edit it to use the environment variable rather than the config file.
And that's it!
In case it helps: SSIS: Indirect configurations ROCK!
-Jamie
|||this link might also help: http://dotnetjunkies.com/WebLog/appeng/archive/2006/05/30/indirectconfigpackagessis.aspx
No comments:
Post a Comment