How can we help you today? How can we help you today?

Integration with SSIS

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
asindlemouat
0

Comments

3 comments

Sort by
  • Andrew P
    Hello Andy,

    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
    Andrew P
    0
  • asindlemouat
    That's great, I can work with that, I can integrate the command line process into the SSIS package, thanks! :D
    asindlemouat
    0
  • Andrew P
    No problem Andy,

    Glad that solves the issue for you!
    Please contact us again if you have any questions or issues.

    Regards,
    AP
    Andrew P
    0

Add comment

Please sign in to leave a comment.