• In Stairway to SSIS Level 2, the Destination OLE DB was configured to host a table named CONTACT by using the SQL CREATE TABLE command. Then, in SSIS Level 3, we see that the Data Flow task does a complete copy of all of the data selected from the Source OLE DB into the Destination OLE DB by running it again and then seeing how many rows a select * from CONTACT query returns.

    Then, to clean it up, we are shown the Delete TABLE CONTACT command in SSMS.

    This all makes sense to me, but does raise a question in my mind - obviously, the second time the Data Flow Task was run, it didn't balk at the CREATE TABLE CONTACT command, even though the CONTACT table already existed. So, can we assume that somewhere behind the scenes, SSIS "wraps" any CREATE TABLE commands with a conditional check and, if it sees that the table already exists, just connects to it and then executes the rest of the Data Flow Task?

    Thanks.