Click here to Skip to main content
15,941,828 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi
I need to use variables with my sql script files using SSIS
let's say, I have a file with following sql statements
SQL
insert into     neu_10_1_2013_rv4.dbo.edi_ack_code values (1, 'TR', 'Transaction Rejected');
insert into     neu_10_1_2013_rv4.dbo.edi_ack_code values (2, 'TA', 'Transaction Accepted');
insert into     neu_10_1_2013_rv4.dbo.edi_ack_code values (3, 'TE', 'Transaction Accepted W/ Errors');


I need to change database name for different databases
like from neu_10_1_2013_rv4 to TARGET

Or please suggest other solution for the same.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900