I agree. Plus bcp also uses less overhead for simple import/exports. So if
the layout is exact between the file and the database, I'd opt for bcp.

Susan

On Tuesday 22 October 2002 06:04 am, Long, Charles (euler:eti) wrote:
> 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] ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page