And the reason is...

You're probably looking for the following:CREATE TABLE #test (
    c1 int,
    c2 char(10),
    c3 varchar(100),
    c4 float
);
INSERT INTO #test (c1, c2, c3, c4)
    VALUES    (1,'A','Adam',9000),
            (1,'B','Adam',9000);

WITH RAW_DATA...

Let's try the following, which adds one record to the original poster's data so that I could be sure my code would pick it up, and it will also identify...

You might also want to consider whether or not you can place the two servers side by side and have the network cards connected to the same router, and then...

I'd be looking for some element with "Can Grow" turned on that may not be readily visible, but it's size is still being accounted for.  Are you using columns?

I'm not sure you understand what an OLE DB Destination is supposed to do.   It's job is to INSERT the rows that flow from the previous element, and if you...

There's only one way around that problem.   You can NOT nest any INSERT / EXEC combinations, so stop doing it.   Nested stored procedures, while handy for separating logic, are not...

If you do come up with an answer, please post back.   Ya never know what MS is up to at times, and strange things can and do occur, from time...