I have a txt file with data as below:
CA,14358,Get WO NE
To load this file, I am using a flat file source and I have declared the data type of all three columns as Unicode String with 500 length in the advance editor..But when I run this package, I am getting an error at the third line:
Invalid character value for cast specification
I get this error at the source adapter only..Can someone please help me out here..
P.S. Not giving a table structure as this a txt file
I am using SSIS 2008