There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Merge Destination Not Merging
I'm trying to use the Merge Destination. I've set up a test using the dbo.DimCustomer table in the AdventureWorksDW2008 database. I have another table (called dbo.NewCustomer) that contains 3 updated records from dbo.DimCustomer and 2 new records. In the data flow, I'm getting the records from dbo.NewCustomer and pushing them into a Merge Destination. I've mapped the columns and everything seems to be okay. When I run the data flow, I see 5 rows going into the Merge Destination and everything turns green. However, when I look at the dbo.DimCustomer table afterwards, nothing has changed.
I've used SQL Server Profiler and I can see the statements coming into the database to create the TVP type and to create the merge stored procedure (both of which look fine). However, I never see the stored procedure getting executed. I've reviewed the TVPMergeDestination.cs code and it seems like it should be calling the stored procedure (when ProcessInput() executes, it calls SendDataToDestination(), which in turn calls m_mergeCommand.ExecuteNonQuery() to run the stored procedure). However, I'm not sure that it is as nothing changes in the dbo.DimCustomer table.