December 4, 2009 at 3:45 am
Hello All,
how to handle flat files that have a varying number of columns along with text delimiter in data?
below shows a sample data of file that uses a semi colon[;] to delimit the columns, and a cursor return[CR] / line feed[LF] to delimit the row and Double Quote as Text Delimiter.
Col1;col2;col3;col4
Emp1;1;Raghav;IT
Emp2;2;"madhu;neethu";BPO
Emp3;1;Shiva
Emp4;4;"Somu;Ranga;Krishna;Keshava";ITICS
Emp5;0
Emp6;1;Reddy
how i can transfer this data of a CSV file into a table using Data transfer?
AS SSIS Data Transfer is having issues while parsing varying number of columns with text delimiter?
help me guys..please......... :exclamation:
December 4, 2009 at 5:32 am
December 4, 2009 at 5:42 am
yeah, i'm working on that workaround also........
can you give me a script where i can split the input buffer string based on column delimiter [;] with giving preference to Text delimiter [''''] also....
for ex:
the below line
Emp4;4;"Somu;Ranga;Krishna;Keshava";ITICS
should split like
Emp4
4
"Somu;Ranga;Krishna;Keshava"
ITICS
?????
December 4, 2009 at 6:51 am
Thanks in Advance
Any other CSV parser code specific to SSIS Script component ?
December 7, 2009 at 6:05 am
Here is the link which helped me to easily solve the CSV reading file and spliiting issue..using a simple RegEx solution
December 3, 2010 at 12:37 am
ssisdfs.codeplex.com is the best resolution!!
Viewing 7 posts - 1 through 7 (of 7 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