SSIS - XML with row delimiter to a single column of a SQL table
0
votes
1
answer
1155
views
I'm trying to upload data from a CSV file into a SQL server table through SSIS package (Flat File source and OLEDB destination). This CSV has comma as column delimiter and {CR}{LF} as row delimiter. This csv file has one column which holds XML data in it. In this XML, they again used {CR}{LF} to make it as a multi-line XML and this XML is placed within a double quotes (""). Ideally, this whole XML needs to be placed in one column however {CR}{LF} makes it as a new row in my table.
Is there any method to have escape sequence and place the whole XML data into a single column?
I'm using Visual studio 2013 and connected to SQL server 2014 database.
Thanks.
Asked by user94864
(11 rep)
Nov 2, 2016, 11:15 AM
Last activity: Mar 23, 2024, 03:47 PM
Last activity: Mar 23, 2024, 03:47 PM