Hi,
In my ssis package, I am using two servers for stage tables and destination tables.
After insert the data from stage server to destination server, I need to update the processed records staus to the stage tables.
It works fine when server names are hardcoded. But my prod environment, they asked to assign the server name to variables and use dynamically through the entire package.
I have no idea. can any one help on this.