Integration with SSIS
asindlemouat
Posts: 3
Hi,
Is there any way to integrate SQL Compare with SSIS?
Scenario
I have a scheduled job that runs an SSIS package where I dynamically import CSV's into a SQL Staging Database after dropping the the table for each file and then copy to the Live Database. The structure of these CSV's changes more often than I'd like hence why I am dynamically creating the table each time. The SSIS package fails when it try's to copy into the Live DB when the structure changes and I am left with an incomplete Live DB.
What I'd Like to Achieve
I'd like to be able to add in a step that uses SQL compare to check if there are any differences before I copy to the Live environment and stop the job.
Thanks in advance!
Andy
Is there any way to integrate SQL Compare with SSIS?
Scenario
I have a scheduled job that runs an SSIS package where I dynamically import CSV's into a SQL Staging Database after dropping the the table for each file and then copy to the Live Database. The structure of these CSV's changes more often than I'd like hence why I am dynamically creating the table each time. The SSIS package fails when it try's to copy into the Live DB when the structure changes and I am left with an incomplete Live DB.
What I'd Like to Achieve
I'd like to be able to add in a step that uses SQL compare to check if there are any differences before I copy to the Live environment and stop the job.
Thanks in advance!
Andy
Comments
Thanks for contacting us!
I don't know of a way to integrate it with SSIS, however you can use it in the command line to compare both databases and pass out the result.
Here is some documentation on using the command line https://documentation.red-gate.com/disp ... mmand+line
Technical Sales Engineer
Redgate Software
Glad that solves the issue for you!
Please contact us again if you have any questions or issues.
Regards,
AP
Technical Sales Engineer
Redgate Software