Text Qualifier in Flat File Source in SSIS
-
Wednesday, February 13, 2013 11:44 AM
Hi All,
I am loading a .csv file into a table. But My problem is as below.
Source file should ideally contain the values as below,
Id, Company Name,Company Desc, Employees
1,abc,abc desc,100
But the SSIS package has should also load the file if the data is some thing like this
Id, Company Name,Company Desc, Employees
1,"abc,xyz","abc,xyz,desc",100
This means, if the name is enclosed in a quote, the value inside the quote must be taken for loading. I have used text qualifiers.. But Its now working. Please let me know if anyone have idea on this.
Thanks,
Rajesh
All Replies
-
Wednesday, February 13, 2013 11:54 AM
give these settings it will work:
Defined Text qualifier " it worked:
Regards,Eshwar.
Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.
- Edited by Eswararao C Wednesday, February 13, 2013 12:06 PM
-
Wednesday, February 13, 2013 12:10 PM
Tried with different kinds of data:
Id, Company Name,Company Desc, Employees
1,"abc,xyz","abc,xyz,desc",100
2,"abc,xyz","abc,xyz,desc",100
3,"abc,xyz","abc,xyz,desc","100"
"4","abc,xyz","abc,xyz,desc",100Regards,Eshwar.
Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.
- Edited by Eswararao C Wednesday, February 13, 2013 12:10 PM
- Marked As Answer by Rajesh S Hegde Wednesday, February 13, 2013 1:47 PM
-
Wednesday, February 13, 2013 1:47 PM
Yes.. Its working.. The problem was, I edited my .csv file excel. So it was inserting two double quotes and thats why it was not working.
.png)
