Morning guys,
I have an ActiveX script that is used to copy files from one directory to another. I'm trying to perform the same task in 2005 but I'm receiving an error. What is a good site or book I can buy for SSIS and programming in SSIS using .NET...

Error Message:
Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Variable is undefined: 'DTSGlobalVariables' Error on Line 28. The step failed.


Code:
Function Main()

Dim oFSO
Dim sSourceFile
Dim sDestinationFile

Set oFSO = CreateObject("Scripting.FileSystemObject")

sSourceFile = "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BackupRepl\ngoladata\ngoladat a_backup_device"
sDestinationFile = "\\svr-ensdb1\d$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BackupRepl\ngoladata\ngoladat a_backup_device"

'Filename format - mmddyy Assets04307
' If Month(Now()) < 10 Then sSourceFile = "C:\PNetExport\assets" & sSourceFile & "0" & _
' Month(Now()) Else sSourceFile = "C:\PNetExport\assets" & sSourceFile & Month(Now())
' If Day(Now()) < 10 Then sSourceFile = sSourceFile & _
' "0" & Day(Now()) & Right(Year(Now()), 2) Else sSourceFile = sSourceFile & Day(Now()) & Right(Year(Now()), 2)
sSourceFile = DTSGlobalVariables("LogFilePath").Value & _
sSourceFile & ".BAK"

'MsgBox sSourceFile

' Filename format - mmddyy Assets04307
' If Month(Now()) < 10 Then sDestinationFile = "G:\PnetArchive\assets" & sDestinationFile & "0" & _
' Month(Now()) Else sDestinationFile = "G:\PnetArchive\assets" & sDestinationFile & Month(Now())
' If Day(Now()) < 10 Then sDestinationFile = sDestinationFile & _
' "0" & Day(Now()) & Right(Year(Now()), 2) Else sDestinationFile = sDestinationFile & Day(Now()) & Right(Year(Now()), 2)
sDestinationFile = DTSGlobalVariables("LogFilePath").Value & _
sDestinationFile & ".BAK"

'MsgBox sDestinationFile


oFSO.CopyFile sSourceFile, sDestinationFile

' Clean Up
Set oFSO = Nothing

Main = DTSTaskExecResult_Success
End Function