Thank you.

Database default collation is SQL_Latin1_General_CP1_CI_AI

Thank you for your kind and considerate response.

I had tried your solution prior to posting on here, but I found some very conflicting information and was hoping someone on here...

Right, I figured that. My real question, though, is how do I insert the data into the denormalized table?

My select: Select TOP 3 FROM EmployeeCountry where EmployeeId = 10001

Will give...

Unfortunately, I cannot normalize the target as the system that will be consuming the data needs it in a flat table.

I am not splitting it back into 2 tables. I am trying to get the CountryIds associated with an EmployeeId in the EmployeeCountry table, then I am going to insert...

They would know which is the EmployeeId and which are the CountryIds by the column headings in the table I will insert the data into.

I will attempt your suggestion and...

No, no warning message came up.

OK figured it out.

I had the OLE DB Destination set to "Table or view - fast load".

Changing it to "Table or view" had it send only the error row....

It would be hard for me to share the package and file because it is dealing with Employee data.

The package has a Data Flow Task which contains only three transformations:...

Thank you.