SSIS conversion problems SQL 2005 - MS ACCESS

I am having data convertsion problems when converting from SQL 2005 to Access.




TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at Data Flow Task [Destination - tblAcode [187]]: Column "ANumber" cannot convert between unicode and non-unicode string data types.

Error at Data Flow Task [Destination -tblAcode  [187]]: Column "TCode" cannot convert between unicode and non-unicode string data types.

Error at Data Flow Task [Destination - tblAcode [187]]: Column "Type" cannot convert between unicode and non-unicode string data types.

Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)
bender007Asked:
Who is Participating?
 
ptjcbConnect With a Mentor Commented:
I would guess that you need to change the SQL columns from varchar to nvarchar (or char to nchar) so that they match UNICODE.
0
 
bender007Author Commented:
Problem solved.
I used the Import Export Wizard and that used a Data conversion modules to change to Unicode Characters.

Thanks for the help.
0
 
ptjcbCommented:
No problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.