I have fixed this problem.

There were duplicate keys being inserted into the primary key column, but the data was not making it into the error output. The duplicate keys...

Hi,

Yes, the primary key GUIDs are in the Excel file.

Each time the insert is attempted a new random set of GUIDs are generated using NewID(). Each new set is...

All the data under Error Output is rejected, on the second pass.

The Error Output data is a result of re-directing the erroneous data, on a fail condition.

Hi,

Thanks for the interest.

Please read the first post, in that I attempt to explain what the problem is.

It's pretty complicated, but my database has the wrong collation property set on...

Hi,

Thanks for the interest. The attached Excel doc has an error output, and the affending rows are there.

As can be seen, the Primary key column (newGiud) does not have...

Hi,

Thanks for the interest. The attached Excel doc has an error output, and the affending rows are there.

As can be seen, the Primary key column (newGiud) does not have...

I'll give your suggestions a try.

I'll be back !!

That's the Error Output section in the Excel file.

The package runs fine with the error handling in it, but the consuming C# app does not display any data, so I...

Hi,

Thanks for the interest.

I've done all that. The database is populated before it fails.

I have included a copy of the data in Excel form. Definately no duplicates in...

Not directly, only through foreign key constraints.

That being the case I would expect the error to be a foreign key constraint problem, not a primary key constraint problem.