Using a wildcard in an activeX script task to copy files

[DanC]

I'm trying to take a file that has a name of agtpacxxxxxx.txt where 'xxxxxx' can be almost anything, and copy it to a new file called agent.txt. I keep getting a path not found error when trying to use the following script:

Function Main()
Dim fso, sourceFile, destFile

Set fso = CreateObject("Scripting.FileSystemObject&quot
sourceFile = "C:\projects\dsc\source\agtpac*.txt"
destFile = "C:\projects\dsc\source\agent.txt"
fso.CopyFile sourceFile,destFile,true

Set fso = Nothing
Main = DTSTaskExecResult_Success
End Function

Can anyone help me out?

thanks

-D

 

[JayKusch]

Could you use an "Execute SQL Task" with the following code ...


EXEC master..cmdshell 'REN C:\projects\dsc\source\agtpac*.txt C:\projects\dsc\source\agent.txt'



Thanks

J. Kusch

 

[bigfoot]

I know what it is: You can not copy multiple files to a single file. That's what dts thinks you are trying to do.

Why not use fso to do a dir on the folder and take the first file it finds? Or at least return a good filename to the copy command.

I hope this helps.