I am trying to rename files in an SSIS package. I have created a ForEach Loop using File Enumeration. I have created two variables - SourceFileName and NewFileName both at the Package level. In the ForEachLoop, I have mapped SourceFileName to Index 0 to obtain the filename. I then have a VB script thta should get the SourceFileName and generate a new name using the date. I am getting DeadLock errors and the script will not run through debug, it apears to hang, so I cannot step through it.
The VBA and error messages are below:
strFileName As String