I'm Testing the Merge Task and here is the situation
I have two sources one is an SQL table
NOT NULL IDENTITY(1,1),
the other one is a flat file that has content suitable to that above tabe, For the SQL table I used an OLE DB Source and I specify a sql command to retrieve the data, the sql commad is as follow:
SELECT Identifier, Content
ORDER BY Identifier, Content
As you can see the command sorts the data.
In the other side (The flat file) I added a sort transorm that recieves data fom that flat file and I configured that sort task to sort data exactly like the ole db one. Now the problem is when I tie the both inputs to the merge task then this last
one still raise the error
Error 4 Validation error. Data Flow Task Merge : The input is not sorted. The "input "Merge Input 1" (924)" must be sorted. DlmCustomer.dtsx 0 0
Inspite of the fact that the ole db source data specifie a command that sort data???
The complexity resides in the simplicity
View Complete Post