Hi: I am trying to accomplish grabbing files off the ftp site and downloading them into a dir. SInce neither the name nor the number of files in the ftp site dir are fixed, I tried something like below but with issues.
1. create a global variable that sets the connectionfile parameter to C:\ConnFOlder\connfile.txt
2. the connfile.txt looks like:
3. An active script tries to set up a connection and download the files as follows:
Dim oConn, sFilename
Set sFilename= "local"
Set oConn = DTSGlobalVariables.Parent.
oConn.DataSource = sFilename
Set oConn = Nothing
Main = DTSTaskExecResult_Success
But I keep getting the error theat object not defined (String:local). Am I missing something? Is there an easier way that I can involve the FTP object into the active script as well and solve the problem?