For a project I'm attempting to move data from a view in source to a table in destination. And this will need to be done periodically. The quickest way to do this seems to be a SSIS package (as this also grants me additional control for possible data transformations in a following phase.
Now, the first time this works excellent, I go through the wizard and the destination table(s) are created and the data imjected. However, when I run the same package a 2nd time SSIS complains that the tables already exist (which is right).
The only way I see how to rectify this is to change the source queries and add an ifexists clause. This though will become a lot of work as I will need to do this for 144 destination tables.
Hence my question, is the if exists clause the only way to capture this or is there an option within the wizard/SSIS to have the package check this for me and only create the table if it doesn't exist yet?