If the file is .csv and matches the record layout exactly I'd probably opt
for bcp because it would be less work to set up. If any data transformation
or validation is required, DTS is the better option.

Charles

> -----Original Message-----
> From: Charles Caroline [SMTP:[Email Address Removed] Sent: Tuesday, October 22, 2002 12:01 PM
> To: LazyDBA.com Discussion
> Subject: bcp or DTS
>
> I need to transfer a csv file into a SQL Server 7 database as a scheduled
> nightly transfer and am not sure which tool is preferable, bcp or DTS.
> Does
> anyone know the pros and cons for each?
>
> Thanks
>
>
> Caroline Charles
> Group Lotus Plc
> Potash Lane
> Hethel
> Norwich
> Norfolk
> NR14 8EZ
> Telephone: +44 1953 608782
> email: [Email Address Removed]
>
>
> ____________________________________________________________________
> "This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. This communication may contain material protected by
> attorney-client privilege. If you are not the intended recipient or
> the person responsible for delivering the email to the intended
> recipient, be advised that you have received this email in error and
> that any use, dissemination, forwarding, printing, or copying of this
> email is strictly prohibited. If you have received this email in error
> please notify the IT Call Centre by telephone on 44 (0) 1953 608000."
>
> [Email Address Removed] http://www.lotuscars.co.uk
> http://www.lotuseng.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page