Windows 7 64bit
SQL Server 2012
I've built a package to read a flat file into a table. The components are:
flat file source->data conversion->ole db destination
-the incoming data types are all DT_STR50
-the db data types are varchar30, int, and nvarchar50
the data conversion makes a 'copy of' that I convert as follows:
DT_STR - DT_WSTR 30 for varchar
DT_STR - DT_WSTR 50 for nvarchar
DT_STR - DT_I4 for int
the varchar and int are ok, but I get a error message for the nvarchar on the ole component stating "Column 'XXX' cannot convert between unicode and non-unicode string data..."
I also tried to create a package through the wizard, which attempted the same conversion, but it also failed.
I found a component someone wrote called Replace Data Conversion (http://rdc.codeplex.com/
) but it doesn't seem to work with VS2010.
any ideas what I may be missing?