I have created a SSIS 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. It still loads the data in TDEVSQL\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 ?
View Complete Post