SSIS Import from comma delimeted flat file

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

SSIS Import from comma delimeted flat file

Author

Topic

savcredit
Starting Member

2 Posts

Posted - 2007-11-27 : 07:33:38

I have a data record as below from teh comma delimeted text file.

660,"CAMPO DE GOLF ""LA FINC ALOGORFA,",7941

SQL 2000 DTS loads this data fine whree the second column is loaded as

ABC ""DAT DESC,",

But Unable to load the record using SQL 2005 SSIS.It considers "CAMPO DE GOLF ""LA FINC ALOGORFA as one column and " as column 2. Is there any options to load this type of data using SSIS.

Thanks

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-11-27 : 07:43:45

Are you using double quotes as text delimiters? If so, then you need to close the quotes on the 3rd column.

savcredit
Starting Member

2 Posts

Posted - 2007-11-27 : 07:52:36

Thanks Rick for the Reply,

I am using " as text delimters.

SSIS reads data as below

Column1 660
Column2 "CAMPO DE GOLF ""LA FINC ALOGORFA
Column3 "
Column4 7941.

Thanks

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-11-27 : 07:57:00

Yes, that would be because you have a comma in your file.

I think you need to wrap it in single quotes. Either that or change you delimiter.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources