"Martin de vroom" <martindevroom@hotmail.com> wrote in message
news:OYvgAOvPDHA.452@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I have a single comma seperated file that I need to copy to a single table
> in a database, this process will occur at least once every single day
> This is not a problem, In fact I have inplemented a DTS package to do it,
> and re run this everyday at a certain time.
>
> My problem is whether this is the correct way to do it. just for the
record
> it works fine.
>
> However I keep reading in places that DTS should only be used for one-time
> transfers, which leaves me wondering why there is an option to save the
> package if it should only be needed once??
>
> Some people say to use bcp, but then i have read in other places that a
bulk
> insert statement runs faster, maybe I am wrong but I though bulk insert
was
> like a wraper for bcp, and that executing a xp_cmdshell(bulk insert .....)
> amounted to the same thing.
>
> can anybody please point out the differences between these methods or
point
> me to an article that compares/contrasts these.
>
> just for the record my comma seperated file i am importing is rougly 1000
> line long..
>
>
> cheers
>
> martin.
>
>