March 24, 2008 at 9:47 pm
Hi,
I exported a few packages from one server into another server, all connection strings on new server still points into old server, when I run those packages, I can change the connection string but I can't save it. I can't find anywhere to permanently update all connections string to point to new server.
any suggestion will be appreciated.
March 26, 2008 at 9:49 am
Hello,
You can set them up as jobs in SQL Agent. When you add a SSIS package it will give you the ability to modify the Data Sources and it will save those changes as part of the job.
It's either that or open the packages in Visual Studio and create Package Configurations. You have a couple of options: XML Configuration File, Environment Variable, Registry Entry, Parent Package Variable, and SQL Server.
I've used XML before but currently I'm using the SQL Server option since I'm storing the packages in MSDB. I like it because I can go directly to the table where I'm storing the configurations and edit them. I found it easier than editing a XML doc.
Steve
March 26, 2008 at 5:02 pm
thanks for all your information, which is very helpful...
and also I found out is that I have to use Agent job account to login to SQL server and then I can modify and SAVE the connection string....if I use other windows account, I can modify it but I CAN NOT SAVE it....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply