Hello
I have an ETL solution that uses a SSIS process task to call a Sql data compare project with the switch of /Synchronize at the end. The comparison and synchronization works however I am not able to exclude all from the “target”. My requirement is to compare and add or update only when matched. I have modified and saved the project from the GUI to exclude all from target with negative results. Note I am using SQL Data Compare 10. Thanks for any assistance in advance
I have an ETL solution that uses a SSIS process task to call a Sql data compare project with the switch of /Synchronize at the end. The comparison and synchronization works however I am not able to exclude all from the “target”. My requirement is to compare and add or update only when matched. I have modified and saved the project from the GUI to exclude all from target with negative results. Note I am using SQL Data Compare 10. Thanks for any assistance in advance