"vineetbatta" <vineetbatta@discussions.microsoft.com> wrote in message
news:816DC10F-5FAA-413D-9632-AEA438311802@microsoft.com...
> Hey i am planning to use the BULK INSERT to copy the data into my Server.
> The
> data is being written to the file by external application.
>
>
> But i want the data that is being written should be deleted after the
> insert. Can BULK INSERT statement support such option to be specified.
> other
> wise my file will grow infintly over time.
>
> Any suggestion or pointer will be helpful.
>
> --
> MCAD
> Vineet Batta

"vineetbatta" <vineetbatta@discussions.microsoft.com> wrote in message
news:08DC46E9-ED63-413D-83E5-B7FA3EC47762@microsoft.com...
> But does BULK Insert can keep track of what data has been pushed to server
> from last time , so that when it runs the second time it just picks up
> delta
> only.
> --
> MCAD
> Vineet Batta
>
>
> "Brian Lawton" wrote:
>
>> BULK INSERT itself will not manage the files for you. You'll have to do
>> that yourself via another script. You might want to look into using a
>> DTS
>> package to manage the BULK INSERT and if successful, execute a script
>> task
>> to move/delete the file.
>>
>> --
>> --Brian
>> (Please reply to the newsgroups only.)
>>
>>
>> "vineetbatta" <vineetbatta@discussions.microsoft.com> wrote in message
>> news:816DC10F-5FAA-413D-9632-AEA438311802@microsoft.com...
>> > Hey i am planning to use the BULK INSERT to copy the data into my
>> > Server.
>> > The
>> > data is being written to the file by external application.
>> >
>> >
>> > But i want the data that is being written should be deleted after the
>> > insert. Can BULK INSERT statement support such option to be specified.
>> > other
>> > wise my file will grow infintly over time.
>> >
>> > Any suggestion or pointer will be helpful.
>> >
>> > --
>> > MCAD
>> > Vineet Batta
>>
>>
>>