Job to create a folder and copy a file 1

[TMRO]

Hi,

I need to create a job in SQL 2000 that will copy a specified file in a specified directory. If that directory doens't exist then it should create it.

Is this possible in SQL?

Thanks,
TMRO

 

[JPMontreal]

Hi,
You will have to use an ActiveX programming in a DTS that uses File system object:


Dim objFSO, objFile, objFolder
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.GetFolder("D:\Data\LOG\SendLog\")
…

For Each objFile in objFolder.Files
…

objFile.move "D:\Data\LOG\SendLog\Test\"


Jean-Paul
Montreal
To send me E-Mail, remove “USELESSCODE”.
jp@USELESSCODEsolutionsvba.com

 

[TMRO]

Thank you

 

[JPMontreal]

Glad I could help.

Jean-Paul
Montreal
To send me E-Mail, remove “USELESSCODE”.
jp@USELESSCODEsolutionsvba.com