Moving a file once it has been imported

#1

Hi all,

I am building a DTS package which picks up a flat file. Once the last sql
t5ask has been completed successfully I would like to move the file to
another folder.
I would also like to timestamp the file in order keep an archive.

Many thanks
Mike

#2

M Stuart wrote:

Quote:

Hi all,

I am building a DTS package which picks up a flat file. Once the last sql
t5ask has been completed successfully I would like to move the file to
another folder.
I would also like to timestamp the file in order keep an archive.

Many thanks
Mike

Try these -

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

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

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

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

Moving a file once it has been imported

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

Moving a file once it has been imported - 02-08-2006 , 06:43 AM

Re: Moving a file once it has been imported - 02-08-2006 , 12:19 PM