January 20, 2009 at 7:09 am
I got a production system where SSIS package is deployed.
I see a job which runs the package (.dtsx) file on a directory.
when i open the file i see source & destination connections strings.
But they are not valid, the servers specified there, does not exist.
Where can i find the connection strings on a package deployed in production ?
January 20, 2009 at 10:26 pm
snowshan (1/20/2009)
I got a production system where SSIS package is deployed.I see a job which runs the package (.dtsx) file on a directory.
when i open the file i see source & destination connections strings.
But they are not valid, the servers specified there, does not exist.
Where can i find the connection strings on a package deployed in production ?
Check your SQL Job step setup on your server. It should contain parameter pointing to the package configuration.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply