Hi everyone
I am getting an SSIS error. I want to import a CSV into SS table. I am using SSIS for this. I am using the Flat File Source -> OLE DB Destination. I am getting below error. Any ideas on how I can fix this?
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [OLE DB Destination [1]]: Column "SYMBOL" cannot convert between unicode and non-unicode string data types.
Error at Data Flow Task [SSIS.Pipeline]: "OLE DB Destination" failed validation and returned validation status "VS_ISBROKEN".
Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
Thank you
March 15, 2023 at 5:34 am
Try this:
Go to the source connection, check the text file properties... make sure you have selected the checkbox Unicode.
=======================================================================
Add a data conversion component between source and destination to change the datatype of Symbol as required.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply