July 27, 2011 at 11:32 pm
Hi every one,
I have an issue with my SSIS package. I have a ssis package which is running fine on a server. when i'm trying to run the package on the other serve, the connection string automatically points to old server even though i changed the connection string to new server. When i,m giving the new server name it is accepting but when i save it it automatically changes to old server name...can any one help me out. Thanks
July 28, 2011 at 4:30 am
Perhaps you have a package configuration in effect? - open the package in BIDS, SSIS menu -> Package Configurations & see if you a configuration set with the connection string in.
July 29, 2011 at 6:10 am
Got bitten by this one a couple of times before I worked out it was the configurations.
July 29, 2011 at 12:20 pm
you might also check if you have a variable/set of variables used as an expression.
For example, I have ConnectionString as a pkg-scope variable. Looking in the Variables window, it's a normal DataSource=blah;InitialCatalog=MyDB; .... connection string.
When I have that variable highlighted in the Variables window and have the properties window up, I have an expression set and EvaluateAsExpression set to True:
"Data Source=" + @[User::cfgDWServerName] + ";Initial Catalog=" + @[User::cfgDWDatabaseName] + ";Provider=SQLNCLI.1;Integrated Security=SSPI;"
where I obviously have servername, dbname as variables also. Database and server are also configurations. I should be able to take this package to the various servers here to run easily.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply