CSV file import

#1

I am importing a csv file into my SQL server 2000 DB using DTS. Is there a
way that I can have the file deleted or emptied after the import is complete.

Thanks

#2

Add an ActiveX Script Task to perform the delete using the File System
Object.

Working with files and the FileSystemObject
(http://www.sqldts.com/default.aspx?292)

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"A.B." <AB (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am importing a csv file into my SQL server 2000 DB using DTS. Is there a
way that I can have the file deleted or emptied after the import is
complete.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

CSV file import

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

CSV file import - 10-05-2005 , 10:28 AM

Re: CSV file import - 10-05-2005 , 11:18 AM