S. Osit wrote:

> Hi All,
>
> I'm not that great with MS-SQL, as I never really have any occasion to
> use it. However, I need to get this one thing working and don't have
> a clue where to start.
>
> I have a comma-delimited file that's delivered to the server every
> night that contains updates to one of the tables. I'm trying to
> create a DTS package that will read in the text file and update all of
> the records contained in it, rather than simply append them to the
> bottom of the table (resulting in duplicate entries).
>
> I know how to schedule it and such, but if anyone can give me some
> tips on the design of the DTS package, it would be much appreciated.
>
> Thanks!
>
> - Steve Osit

> I'm not that great with MS-SQL, as I never really have any occasion to
> use it. However, I need to get this one thing working and don't have
> a clue where to start.
>
> I have a comma-delimited file that's delivered to the server every
> night that contains updates to one of the tables. I'm trying to
> create a DTS package that will read in the text file and update all of
> the records contained in it, rather than simply append them to the
> bottom of the table (resulting in duplicate entries).
>
> I know how to schedule it and such, but if anyone can give me some
> tips on the design of the DTS package, it would be much appreciated.

Erland Sommarskog <esquel@sommarskog.se> wrote in message news:<Xns95903AEC291FYazorman@127.0.0.1>...
> S. Osit (steveosit@gmail.com) writes:
> > I'm not that great with MS-SQL, as I never really have any occasion to
> > use it. However, I need to get this one thing working and don't have
> > a clue where to start.
> >
> > I have a comma-delimited file that's delivered to the server every
> > night that contains updates to one of the tables. I'm trying to
> > create a DTS package that will read in the text file and update all of
> > the records contained in it, rather than simply append them to the
> > bottom of the table (resulting in duplicate entries).
> >
> > I know how to schedule it and such, but if anyone can give me some
> > tips on the design of the DTS package, it would be much appreciated.
>
> I don't know DTS, so I can't help on that part. I would use BCP to load
> the file into a staging table, and then update the target table from
> there. Having some process read each row and then look it up in the target