Updating data using ssis britney spears and justin timberlake dating
Now that we have our source configured we can connect it directly to the Premium ADO. In configuring our destination component we will select the 'Target Database' connection manager we established earlier. As mentioned this action a combination of Insert and Update which is what is allowing us to skip the lookup & conditional split steps traditionally used in incremental data loads in SSIS.
From there we can select the appropriate table or create a new one.
We will also select 'Use Bulk' to speed up performance (note as of the writing of this blog post, this option is only supported when working with SQL or Oracle databases).
Over on the Columns Page, you will notice any fields from the source with the same name as the destination have already been mapped.
We can use this field to filter out any data that has not been updated since the last pull which is being stored in an SSIS variable.
We can then complete my component configuration and execute our task.
For handling deleted records and other more advanced requirements there are many other tricks you can use using the SSIS Productivity Pack, we will cover some of them our next blog post.
This solution requires SSIS Productivity Pack, you can click here to download the free developer's license to get started.
Notice a SQL Query is already generated for us based on the columns stored in that table.
The table we are using in this example is tracking changes using the field labeled Modified On, this is a datetime field the database is configured to update when a row is added or modified.
I will not go into details about any of that in this post, but I will use Protection Level as an example default property you want to change in many SSIS packages at the same time.