I'm working on a SSIS package that is taking data from a text file to a MS SQL 2005 database. I'm getting an error saying,
Columns "column1" and "column1" cannot convert between unicode and non-unicode string data types.
After receiving that error, I have added a data conversion process to convert the colmn to a unicode text stream. When I use that new column, I'm receiving the following errors:
[OLE DB Destination ] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
[OLE DB Destination ] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
[DTS.Pipeline] Error: component "OLE DB Destination" (2986) failed the pre-execute phase and returned error code 0xC0202025.
I have the destination columns set to NVarchar(50). What do you suggest that I do to resolve this? Thanks.