Hey Jeff,

This will help so many folks... My data is comma delimited with quotes around only on those field that has embedded comma (each file can have different fields and...

Yeah Jeff there has to be a way...I don't know how you have time to help us all over here... you are awesome.

there was typo .. this works fine.

Hey Jeff,

Thanks for taking time in assisting me... you have always been a huge help. I guess my next option should be to use SSIS where I will use variables...

Great Thanks a lot Jeff.

Hey Jeff,

Thanks a lot for your response. I tried that and I got this error:

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

I am running this on:

Microsoft SQL Server 2005...

Hey Jeff,

This is a good solution ... using format file. I am wondering what if we don't know which column has the double quotes? Is there any default delimiter we...

bumping this up.. thanks

What if the file is either comma or pipe delimited with Quotes on fields that has embedded comma or pipe? Also, the file names will be a logging table which...

bumping the ticket.

Manu,

Thanks for the link... solution there should help...

Actually I have the same problem as the person in that thread had. The quotes will be there for only fields that has...

Exec Xp_cmdshell 'dtexec /sq pkgOne /ser productionServer'

Search for dtexec in help for more info.

KeyCode, MemAcctNum, NATitle, NName

205509,0505488528,,"Rip, Winkle"

205501,0505488111,,"Tiger, Scott"

Sample data.

Quotes only for fields that has embedded comma.

First row has column name...

Problem is we cannot create format file that easily as every file can have different number of fields in it.