Thanks for the hint. I ended up using Now().ToShortTimeString.

Thank you for your help. Wouldn't an Execute SQL Task on an Oracle table require a linked server? Also, I've been told that I will have very limited...

I've created the Script Task and a variable, but I have no idea how to get the Script Task to assign the time of day to the variable.

Thanks! Do I need a script task for this or some other kind of task?

I have partially answered my own question. If I check by

If

source.Inventory_Item_Id = destination.Inventory_Item_Id

AND

source.Creation_Date = destination.Creation_Date

AND

source.Last_Updated_Date <> destination.Last_Updated_Date

That won't take into account deleted records. So...

Also, is the looping process that the boss wants really necessary? Is breaking up the data into 15-day chunks going to improve performance or slow it down? After...

How about this?

If

source.Inventory_Item_Id = destination.Inventory_Item_Id

AND

source.Creation_Date = destination.Creation_Date

AND

source.Last_Updated_Date <> destination.Last_Updated_Date

Then start "reconciliation" process.

Can I use a Lookup to do this? Will this properly prevent too many source rows...

Thanks for the insight! I have done some research on CDC, which is leading me to more questions. Is it okay for me to start a new thread...

The boss would like us to move toward an MDM scenario. Where can I learn more about that in a Microsoft context?

Informatica was used extensively at my previous job. In fact, my bosses asked us to do proof-of-concept comparisons between SSIS 2005 and Informatica (I forgot which version). Here...

Yes, but he wants me to compare and change the data in 15-day chunks. Would putting that into a loop necessarily boost performance?

I agree, but my boss thinks the performance will be better if I break the data up into 15-day chunks. Do you think that would be necessary? It...

We are using SQL Server 2008 R2. From what I understand, we are going to deal with about a million rows.

The Slowly Changing Dimension worked very well, thanks!

Thanks to you, I think I'm gaining an understanding of Findstring, except for one thing: how do figure out the LAST occurrence of the "\" character within the string?