| Author | Forum: General Questions Topic: FTP ActiveX in a DTS Package? |
| cmillerst From: Charlotte, NC USA Posts: 1 Member Since: 11/05/08 |
posted November 5, 2008 12:04 PM I'm using the ActiveX FTP control in a vbscript/DTS package trying to write a file to a mainframe. There is some interesting behaviour happening. I have the following code: Dim dtsFileName dtsFileName = DTSGlobalVariables("FileName").Value ftpServer.Store dtsFileName, DTSGlobalVariables("TempFilePath").Value & DTSGlobalVariables("FileName").Value This returns an error: 11101 Description: 554 Requested action not taken: GDG name conversion failed. After looking at the forum, I found that this requires a single quote to work properly in a test script I wrote: Dim dtsFileName dtsFileName = "'" & DTSGlobalVariables("FileName").Value & "'" ftpServer.Store dtsFileName, DTSGlobalVariables("TempFilePath").Value & DTSGlobalVariables("FileName").Value Now, here is the crazy part, the above code works fine in my test script. When I put it in a DTS package and run the package from the list of packages, I get the following error: 11101 Description: 501 Invalid data set name "''TEST.TG2.TG3BPSDB.INPUT(+1)''". Use MVS Dsname conventions. Why would the control be putting two single quotes instead of just the one? Thanks for any insight you can provide. |
| Jason Farrar (Admin) From: Oneida, NY USA Posts: 223 Member Since: 07/24/07 Extra Support Options Custom Application Development |
posted November 5, 2008 2:49 PM Hi, We are not entirely sure what is going on but the control is not adding an extra set of single quotes, the DTS engine is likely noting that you are passing a string value and wrapping it in single quotes for you but you may need to do it manually in testing because the script is not running through the DTS engine. So the root problem may be the "GDG name conversion failed" error but unfortunately we do not know what that means. ------ |
| Reply | General Questions Topics | Forums |
This site is powered by
PowerTCP WebServer for ActiveX
|