How To FTP To Host(Mainframe)?

Hi,

I am trying to send files over to an ftp server on Mainframe using scripts that is provided in this link, but I can't get it to work.
The problem is the sendfile method concatinates the source file name to the MVS dataset name which causes the issue.

Here's my code (FTPConn is a connecation mgr for FTP):


Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime



Public Class ScriptMain


Public Sub Main()



Dim mgr As ConnectionManager

mgr = Dts.Connections("FTPConn")



Dim conn As FtpClientConnection

conn = New FtpClientConnection(mgr.AcquireConnection(DBNull.Value))



Dim toFiles As String

toFiles = "ftpp.a.b.xxxxx.yyyyyy.int"

Dim fromFiles(0) As String

fromFiles(0) = "c: est.txt"

Try


conn.Connect()

conn.SendFiles(fromFiles, toFiles, True, True)

Catch ex As Exception





Finally

conn.Close()

End Try





Dts.TaskResult = Dts.Results.Success

End Sub



End Class



Output:


SSIS package "Package.dtsx" starting.

Error: 0xC001602A at Package, Connection manager "FTPConn": An error occurred in the requested FTP operation. Detailed error description: 200 Representation type is Ascii NonPrint

200 Port request OK.

501 Invalid data set name "ftpp.a.b.xxxxx.yyyyyy.int/test.txt". Use MVS Dsname conventions.