Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Indirect Package Configuration Expand / Collapse
Author
Message
Posted Sunday, August 4, 2013 9:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:28 AM
Points: 16, Visits: 113
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?


Thanks
Rahul Sahay
Post #1480809
Posted Sunday, August 4, 2013 10:15 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:15 PM
Points: 3,027, Visits: 2,631
My first thought is that the environment variable is not known to the process that is attempting to run the package (e.g. SQL Server Agent) - probably because the environment variables are setup when the process starts and you created a new environment variable some time after that.

Try re-starting SQL Agent (assuming that you are using SQL Agent to run the package)



Post #1480811
Posted Monday, August 5, 2013 10:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:28 AM
Points: 16, Visits: 113
Thanks for the reply.....but it is not working after restarting the services...
Post #1480994
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse