I am running this activex script on a server which searchers for a file
b.txt and renames it as ba.txt on the c drive of a server.I get the
error vb script error error code 0 when executing the movefile step
oFSO.MoveFile sSourceFile , sDestinationFile.
Both these files exists on the server.

What could be going wrong?Using xp_cmdshell and dos rename command i
can rename the files,


AG

option explicit
Function Main()

Dim oFSO
Dim sSourceFile
Dim sDestinationFile
Dim dds

Set oFSO = CreateObject("Scripting.FileSystemObject")
sSourceFile ="C:\b.txt"

sDestinationFile = "C:\ba.txt"
msgbox sSourceFile
msgbox sDestinationFile
oFSO.MoveFile sSourceFile , sDestinationFile
' Clean Up'
Set oFSO = Nothing
Main = DTSTaskExecResult_Success
End Function

Thanks for the great repo.

Unfortunately I can report that it works for me.

This does not work for you when you execute the single task manually?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"AG" <ajayz90 (AT) hotmail (DOT) com> wrote