Bulk Copy Program

Hi
I have a flat file that contains records many records. The first field
states the following for each record:
'I' = insert
'U' = update
'D' = delete
Is it possible for the BCP to achieve this objective? I know there be some
coding involved. I also noticed that there's an ODBC API that I can use in
..NET.
I'm not to sure but can BCP delete or update records?
Thanks in advance
Ross
Hi,
BCP can just copy the data into a file and then using a BCP IN loading back
to a table. Using this you cant dor a delete or update.
Thanks
Hari
MCDBA
"Ross Pellegrino" wrote:

> Hi
> I have a flat file that contains records many records. The first field
> states the following for each record:
> 'I' = insert
> 'U' = update
> 'D' = delete
> Is it possible for the BCP to achieve this objective? I know there be some
> coding involved. I also noticed that there's an ODBC API that I can use in
> ..NET.
> I'm not to sure but can BCP delete or update records?
> Thanks in advance
> Ross
>
>
|||Thanks for the info.
Ross
"Hari Prasad" <HariPrasad@.discussions.microsoft.com> wrote in message
news:4352FAE8-F9EE-4C92-8E89-E372F442538B@.microsoft.com...
> Hi,
> BCP can just copy the data into a file and then using a BCP IN loading
back[vbcol=seagreen]
> to a table. Using this you cant dor a delete or update.
> Thanks
> Hari
> MCDBA
>
> "Ross Pellegrino" wrote:
some[vbcol=seagreen]
in[vbcol=seagreen]