Hello,

I am trying to create a file name that puts in the current date and
time at the time of creation. I am able to create it just fine without
the date and time stamp but not with it. Can someone out there tell me
what I am doing wrong? I keep getting a type mismatch error. I think
the problem is somewhere with the DTSGlobalVariables. Code is attached
-

Function Main()
dim fso
dim FileName

set fso = CREATEOBJECT("Scripting.FileSystemObject")

FileName = "C:\test " & Date & " " & Time &".txt"

DTSGlobalVariables(FileName).Value

fso.CreateTextFile FileName

set fso = Nothing

Main = DTSTaskExecResult_Success

End Function

Thanks.

Hi,

the matter is that you can't create a file with some special characters
in it such as "/" and ":".
Thus, you should replace these characters...

As an example, your filename could be the following :
FileName = "C:\test " & Replace(Date, "/", "-") & " " & Replace(Time,
":", "-") & ".txt"

This should solve your problem.

Cédric Del Nibbio
MCP since 2003
MCAD .Net
MCTS SQL Server 2005

LionsDome a écrit :