December 6, 2017 at 1:03 pm
Hi Guys,
Here is the one Data from my source is erroring out.
"E:60 Pic: 20 years and 11 seconds" - The Travis Loy Story"",
The source file is in .csv format and In SSIS Flat file source I am using TEXT QUALIFIER = ". He is removing first " in the source file but the second one. If I remove second double quote (")
from the file, it is working. Any advice how can I fix this issue?
December 6, 2017 at 1:07 pm
rocky_498 - Wednesday, December 6, 2017 1:03 PMHi Guys,
Here is the one Data from my source is erroring out.
"E:60 Pic: 20 years and 11 seconds" - The Travis Loy Story"",The source file is in .csv format and In SSIS Flat file source I am using TEXT QUALIFIER = ". He is removing first " in the source file but the second one. If I remove second double quote (")
from the file, it is working. Any advice how can I fix this issue?
Try not using a text qualifier. Then if you have to remove quotes later in the process, do that.
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
December 6, 2017 at 3:30 pm
Phil,
Thank You for your reply, It will solve this issue that I am having. However, If I have data with extra, it will break the process that is the reason I am using the double quote (") as a Text Qualifier.
Thank You.
December 7, 2017 at 5:50 am
rocky_498 - Wednesday, December 6, 2017 3:30 PMPhil,Thank You for your reply, It will solve this issue that I am having. However, If I have data with extra, it will break the process that is the reason I am using the double quote (") as a Text Qualifier.
Thank You.
OK, then I suggest you change your text qualifier to something more unusual. The pipe character (|) is one common option.
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