October 18, 2022 at 3:37 pm
Multiple single quotes in my column's data value is causing my SSIS pkg load to fail. I extract from a SQL 2016 table and load to a flat file.
These 3 column nvarchar(80) values load successfully into my flat file: TE'SHAY and: ADD'L MODEM and: * HENRY'S MARKET
This 1 column nvarchar(80) value fails loading into my flat file: 'TRE''QUAN' <-- this is the actual data contained in the column value including the 4 single quotes in the column (those 2 in the middle are 2 single quotes, not a double quote)
My target flat file attributes include: code page: 1252 (ANSI - Latin I), DataType: Unicode string [DT_WSTR], Column Delimiter: Vertical Bar
I've tried a few different Data Conversion tasks but no luck. Any thoughts on this one? thx in advance!
October 18, 2022 at 3:53 pm
PLEASE DISREGARD the above request.. this was NOT my issue. thx anyway
October 18, 2022 at 5:48 pm
My resolution included adding a DATA CONVERSION task to my extract from SQL table to a flat file .. specifying Data Type: text stream [DT_TEXT] and Code Page 65000 (UTF-7)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply