StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POData transfer from a view from one database to a table in another database
text
Body
copied!<p>I am just trying to find out whether this is the right way to do this task. Any other suggestions to improve this is greatly appreciated.</p> <p>I have the following on my SSIS package.</p> <p><img src="https://i.stack.imgur.com/m0Fi4.jpg" alt="enter image description here"></p> <ol> <li>Data Flow task and established a OLE DB connection to the source database where the view is.</li> <li>Execute SQL task - I am executing a query with a INSERT INTO Destination Except (all those records that are already there from the source.)</li> <li>Send mail task is to send out an email.</li> </ol> <p>How to know that the data transfer is successful? So that I can use the send mail to indicate success or failure.</p> <p>How to schedule this package so that it runs automatically (Every Tuesday.)</p> <p>I have tried the suggestion below. Please refer to the new Data Flow task.</p> <p><img src="https://i.stack.imgur.com/3vADS.png" alt="enter image description here"></p> <p>OLE DB Source - Points to a view in database server 1 Lookup gets all the rows from OLE DB source. (the rowcount on source and on the lookup) matches.</p> <p>On the lookup task, I have configured error output to use 'Redirect row' on all the mapped columns.</p> <p>On the OLE DB Destination (Destination table where it already has a subset of records from the source. So the Configured Error output to get unmatches rows for insert.</p> <p>When, I execute the package - I am getting an Primary key constraint error as - Cannot insert duplicate key.</p> <p>Any suggestions? </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload