Scenario is that i have created system variable for storing xml config file called config.dtsconfig on my test network. Environment variable name is ssis and path is:
ssis ==> d:/packages/config/config.dtsconfig
I build the file henced the manifest file got created. Till this point everything was working fine on test network.
i copied the manifest file to the prod server and did sqlserver deployment. Created environment variable SSIS and pointed to e:/config.dtsconfig and made changes in the datasource . now when i am running the packages from MSDB i am getting error " Not able to acquire the connection manager". I earlier copied the config file also to the E: drive and then made the environment variable of prod server talk to this file.
Can you please guide me as to where i am going wrong?