File Create by DTS

#1

Is there a way that I can create a text file as the last step in the DTS
package that reads 'The extract was successful' ?. Is there a activeX or VB
code that can do this ? If so, can someone help me with code ?

Thanks in advance.

#2

Simply use an Active Script task and the FileSystemObject

Something like this

http://msdn.microsoft.com/library/de...filesystem.asp

Allan

"DXC" <DXC (AT) discussions (DOT) microsoft.com> wrote

Quote:

Is there a way that I can create a text file as the last step in the DTS
package that reads 'The extract was successful' ?. Is there a activeX
or VB
code that can do this ? If so, can someone help me with code ?

Thanks in advance.

#3

That did it...............Thanks........

"Allan Mitchell" wrote:

Quote:

Simply use an Active Script task and the FileSystemObject

Something like this

http://msdn.microsoft.com/library/de...filesystem.asp

Allan

"DXC" <DXC (AT) discussions (DOT) microsoft.com> wrote in message
news:0AE13581-057E-4239-BC19-1118C63E1B3B (AT) microsoft (DOT) com:

Is there a way that I can create a text file as the last step in the DTS
package that reads 'The extract was successful' ?. Is there a activeX
or VB
code that can do this ? If so, can someone help me with code ?

Thanks in advance.

#4

No worries

"DXC" <DXC (AT) discussions (DOT) microsoft.com> wrote

Quote:

That did it...............Thanks........

"Allan Mitchell" wrote:

Simply use an Active Script task and the FileSystemObject

Something like this

http://msdn.microsoft.com/library/de.../en-us/script5
6/html/jsobjfilesystem.asp

Allan

"DXC" <DXC (AT) discussions (DOT) microsoft.com> wrote in message
news:0AE13581-057E-4239-BC19-1118C63E1B3B (AT) microsoft (DOT) com:

Is there a way that I can create a text file as the last step in the
DTS
package that reads 'The extract was successful' ?. Is there a
activeX
or VB
code that can do this ? If so, can someone help me with code ?

Thanks in advance.

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

File Create by DTS

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

File Create by DTS - 09-06-2005 , 08:23 AM

Re: File Create by DTS - 09-06-2005 , 01:11 PM

Re: File Create by DTS - 09-07-2005 , 08:50 AM

Re: File Create by DTS - 09-07-2005 , 01:31 PM