sql server dts: 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

I think you are asking if BULK INSERT would allow you to delete from a file which has data
appended to it by an external application?

In that case no BULK INSERT will not be able to go in to the file and remove data.

Will the external app create the file if it is not there already? If yes then you can
have your process after the BULK INSERt remove the file (delete)

Allan


On Wed, 31 Aug 2005 14:25:30 -0700, "vineetbatta" <vineetbatta@discussions.microsoft.com>
[quoted text, click to view]


Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.