What are the challenges you face when working across database platforms? Take the survey
Options

DB Sync using BATCH file Versus SSIS

DBNewbie_2007DBNewbie_2007 Posts: 47 Bronze 3
Currently, we are using a lot of "command line" data compares/syncs using ".sdc" files. Needless to say, since these are batch files that run weekly, we have quite a few scheduled processes on our server.

I was thinking that it might be easier (and somewhat more managable for me) if I execute the "command line" process in SSIS, wrapped around an SSIS Execute process task? I can use the result of the SSIS execute process to also send me an email at the end to let me know if the process completed correctly.

Does anyone have experience or has anyone tried this already?

Thanks! :)

Comments

Sign In or Register to comment.