all groups > sql server dts > september 2005 >
You're in the

sql server dts

group:

File Create by DTS


Re: File Create by DTS Allan Mitchell
9/6/2005 12:00:00 AM
sql server dts:
Simply use an Active Script task and the FileSystemObject

Something like this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/jsobjfilesystem.asp

Allan

[quoted text, click to view]
File Create by DTS DXC
9/6/2005 6:23:05 AM
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.
Re: File Create by DTS Allan Mitchell
9/7/2005 12:00:00 AM
No worries



[quoted text, click to view]
Re: File Create by DTS DXC
9/7/2005 6:50:10 AM
That did it...............Thanks........



[quoted text, click to view]
AddThis Social Bookmark Button