0

We deployed the packages from an old server to a new server. How to change the connection string i.e initial catalog or server name parameter from Agent job -> Configuration -> Connection manager? Is there a possibility to do it from here?

I'm receiving the below error if I'm changing the data source and servername.

enter image description here

tinlyx
3,84014 gold badges50 silver badges79 bronze badges
asked Oct 15, 2019 at 6:55
1
  • In the future, you can consider using environment variables, that are stored in the catalog and point your packages to use them for the server names. That way you can easily change the server names for lots of packages\projects at once, or easily manage deployments from dev to prod, etc. Commented Mar 23, 2021 at 18:29

1 Answer 1

1

After SSIS package deployed to new environment still it may use old connection string.

how to change the connection string i.e initial catalog or server name parameter from Agent job> configuration> connection manger .Is there a possibility to do from here ?

Yes, It's possible when you are sysadmin and you can change manually by following:

Right click on AgentJob -> Properties -> Job step -> Configuration -> Connection Managers

Below Connection Managers -> select Name of database then on properties ->

  • Connectionstring -> Data Source=yourServerName;InitialCatalog=Databasename;Provider=SQLNCLI11.1;IntegratedSecurity = SSPI;Auto Translate=False; (you can edit Data source and intial catalog manually)

and

  • Servername = 'yourservername'
answered Oct 16, 2019 at 0:42

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.