I m using flat file connection manager my source is csv file
which contains TOP 5 rows from AdventureWorks.person.contact
select top 5 * from AdventureWorks.Person.Contact - my source as csv
"AdditionalContactInfo"- column is XML data type in Destination.
When I use Bulk Insert Task I am getting error.
[Bulk Insert Task] Error: An error occurred with the following error message: "XML parsing: line 1, character 33, whitespace expected".
I have tried changing code page to ANSI 1252 and SSIS datatype for AdditionalContactInfo - DT_WSTR.
Nothing worked. My motive here is to learn, nothing business-logic behind this question.
View Complete Post