All geek questions in one place

Changing the SSIS 2005 connection server for "Executing an SQL task" does not affect -

I created SSIS packages some time ago, today I need to reassign them to another SQL server. I have a bunch of SQL Execute Tasks tasks, for which their Connection property has changed to another server.

I created a new connection manager, double-clicking on each of the sql tasks, changed their Connection property to a new one, launched it. This failed, the error was that he could not find the old connection. I restarted the project, none of the SQL Server tasks seemed to launch a new connection manager. I opened the .dtsx files, tried to find the old server name somewhere and manually change it, but could not find the old server.

What do I need to change to get rid of the old SQL Server and connect it to the new correct data source.

I work in VS2005, on a Windows 2008 x64 machine (I don’t know if this matters or not).

Thanks.

+4
source share
4 answers

I have seen this before when package configurations are enabled. Make sure it is not, recompile and try again.

+3
source

all you had to do was change the connection string in the old connection manager

create a new one if you deleted the old one and in all tasks select a new one, even if you create a new one with the same name as the old one, it will not work, because the internal pointer is used somewhere

+2
source

Check if package configuration is enabled. The package can still get the old server configuration from the package configuration.

+2
source

try recompiling after making changes.

0
source

Source: https://habr.com/ru/post/1286323/

More articles:


All Articles