[dba-SQLServer] Bulk insert

DTS may be more flexible but it is significantly slower than BULK INSERT. 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stephen
Hait
Sent: Tuesday, May 01, 2007 7:23 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Bulk insert

Could you possibly use DTS instead of BCP? It should allow you to specify
your text qualifier.

Stephen

On 5/1/07, JWColby <jwcolby at colbyconsulting.com> wrote:
> I am trying to to use the bulk insert to pull csv file data in to a table.
> It appears that I have everything except for the fact that the data is 
> enclosed in "" - "SomeData".  This is common in CSV files in order to
"wrap"
> commas which would otherwise be interpreted as a field delimiter.  
> Bulk Copy has a Line Terminator and a Field terminator as a parameter 
> but I do not see anyplace to specify what is known as a "Text 
> qualifier" (the " surrounding the data).
>
> Is there ANY way to do this?  CSV files are very common and text 
> qualifiers are so common that the import / export wizard allows you to
specify them.
> Surely bulk insert must understand them.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>