Sample Header Ad - 728x90

SSIS - Data Import & export wizard - existing tables

1 vote
1 answer
1139 views
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?
Asked by Dirk R. (45 rep)
Jul 20, 2017, 08:52 AM
Last activity: May 8, 2025, 07:01 AM