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.
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.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy