CODEWITHSUNDEEP
ssissql-server-2012
Omega
Omega

Reputation: 185

Parameter for Database server in SSIS

I have a SSIS package(say LOADCON) created in server SDEU1123 to load some data from text file to table CONTENT001.

Now I have the same table(CONTENT001) in another servers as well SDEU1124 and SDEU1125 and I want to load these table using the same package LOADCON using some parameter. I just need to change the value of the server using this parameter.

I have tried creating a parameter using PROJECT.PARAMS. But I'm not sure how to use this and where should I refer this.

I have checked this How to make the server name dynamic in an SSIS package. But this seems to be too old.

Upvotes: 0

Views: 1318

Answers (1)

Benzi
Benzi

Reputation: 448

You didnt mention where you wanted to change the value.

Here are the options that I know;

If you want to implement it when you develop your SSIS package;

  • go to connection managers.
  • choose your connection.
  • go to the properties window and press expressions.
  • on the property expressions editor choose connection string and press [...] on the expression field.
  • open variable and parameter and choose your relevant PROJECT.PARAMS ( you need to create two for this scenario)

enter image description here

If you want to change it on the server - after deploy (SSISDB catalog);

Upvotes: 3

Related Questions