SQL Server Config issue
I have created a package . The source is DEVSQL\SQL1 with windows auth and the destination is TDEVSQL\SQL1 . I created a XML config file for source so i can change it for QA and DEV . I also created a config table in SQL server on DEV\QA\PROD so the package can dynamically get the destination details(TQASQL\SQL1) and TPRODSQL\SQL1. Somehow when i execute the package using Execute Package utility , the destination does not change from TDEVSQL\SQL1 to TQASQL\SQl1 if i pass the config file that connects to QASQL\SQL1. We will copy the dts files manually to deploy it on QA\PROD and do not use main manifest to deploy. Is it a bug in SSIS or is there any solution to it ? Satish
April 12th, 2011 7:57pm

You can replace the environment variable with an XML configuration if that is an option.MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2011 12:56pm

I am using XML config as mentioned in my original post. I was able to replicate the same issue on my work colleague machine . Satish
April 13th, 2011 2:02pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics