I need to send a table data to two databases in a server where I can select any one of the database with a parameter selection in SSIS can anyone help in that please?

I have a local server in that i created two databases A and B. Now when i select database A in ssis package i can send the data to A or by selecting B i can select the data to B database. Can i do that?

CodePudding user response：

Yes, you can do that. You can make the database connection string a variable. You can even pass the variable value through your SQL server job.

If you don't want to pass the variable value whenever you want to run the SQL server job.. You can prepare two SQL server jobs, that use the same package and each job can pass its own database connection string variable value.