FTP from a mainframe (z/os) box

Has anyone been able to use an ftp task to pull a flat file from a z/os mainframe? The ftp task appears to want the remote file to begin with a /, which pulls you into unix system services on z/os.

Thanks!
HarryHarry,

We do not support paths that do not start with a /. Please feel free to file a bug about this.

Thanks,
Matt|||Same problem makes it impossible to pull a file off a VMS system. Ironic that in the land of the backslash, the Unix convention is mandatory ....
|||Well now, that's a big bummer. About all of my interfaces involve mainframe datasets.
|||

Will Wilson wrote:

Well now, that's a big bummer. About all of my interfaces involve mainframe datasets.

I worked around this by installing IIS on the SQL Server 2005 and writing scripts on the VMS side to transfer the files into Windows instead. This is actually more flexible as the scripting capabilities of VMS (DCL) are far more powerful. You can then use the Foreach Loop container to iterate through the files in SQL Server 2005.

The downside is that I don't like having an FTP service running on my database server; also, this workaround requires you to have sufficient access to the mainframe to create the scripts etc. The latter is not an issue in my case as I administer both machines.

FTP from AS400

I have been handed the directive that I am to ftp flat files from our AS400 to the SQL server where the web interfaces will read the data.

I need to know if anyone out here knows how to automate the FTP download from the AS400 system.

I don't know any UNIX and even if I did the SQL box is also running a 3rd party shipping label system that disallows the use/installation of MSK Toolkit.

I thought I could use the FTP Task in the DTS package but I don't know what to put for the internet location and this is certainly not a Mapped path.

Please Help!

There is a built-in ftp command-line utility in Windows Server 2003 that you can use to automate the ftp download. The FTP task in DTS should take a url like ftp://some_server.com/files/d1.dat. If you need more details on the DTS/SSIS task then please post this question in the SQL Server Integration Services forum here.

FTP from a mainframe (z/os) box

Has anyone been able to use an ftp task to pull a flat file from a z/os mainframe? The ftp task appears to want the remote file to begin with a /, which pulls you into unix system services on z/os.

Thanks!
HarryHarry,

We do not support paths that do not start with a /. Please feel free to file a bug about this.

Thanks,
Matt|||Same problem makes it impossible to pull a file off a VMS system. Ironic that in the land of the backslash, the Unix convention is mandatory ....
|||Well now, that's a big bummer. About all of my interfaces involve mainframe datasets.
|||

Will Wilson wrote:

Well now, that's a big bummer. About all of my interfaces involve mainframe datasets.

I worked around this by installing IIS on the SQL Server 2005 and writing scripts on the VMS side to transfer the files into Windows instead. This is actually more flexible as the scripting capabilities of VMS (DCL) are far more powerful. You can then use the Foreach Loop container to iterate through the files in SQL Server 2005.

The downside is that I don't like having an FTP service running on my database server; also, this workaround requires you to have sufficient access to the mainframe to create the scripts etc. The latter is not an issue in my case as I administer both machines.

FTP from a mainframe (z/os) box

Has anyone been able to use an ftp task to pull a flat file from a z/os mainframe? The ftp task appears to want the remote file to begin with a /, which pulls you into unix system services on z/os.

Thanks!
HarryHarry,

We do not support paths that do not start with a /. Please feel free to file a bug about this.

Thanks,
Matt|||Same problem makes it impossible to pull a file off a VMS system. Ironic that in the land of the backslash, the Unix convention is mandatory ....
|||Well now, that's a big bummer. About all of my interfaces involve mainframe datasets.
|||

Will Wilson wrote:

Well now, that's a big bummer. About all of my interfaces involve mainframe datasets.

I worked around this by installing IIS on the SQL Server 2005 and writing scripts on the VMS side to transfer the files into Windows instead. This is actually more flexible as the scripting capabilities of VMS (DCL) are far more powerful. You can then use the Foreach Loop container to iterate through the files in SQL Server 2005.

The downside is that I don't like having an FTP service running on my database server; also, this workaround requires you to have sufficient access to the mainframe to create the scripts etc. The latter is not an issue in my case as I administer both machines.

sql

FTP from a mainframe (z/os) box

Has anyone been able to use an ftp task to pull a flat file from a z/os mainframe? The ftp task appears to want the remote file to begin with a /, which pulls you into unix system services on z/os.

Thanks!
HarryHarry,

We do not support paths that do not start with a /. Please feel free to file a bug about this.

Thanks,
Matt|||Same problem makes it impossible to pull a file off a VMS system. Ironic that in the land of the backslash, the Unix convention is mandatory ....
|||Well now, that's a big bummer. About all of my interfaces involve mainframe datasets.
|||

Will Wilson wrote:

Well now, that's a big bummer. About all of my interfaces involve mainframe datasets.

I worked around this by installing IIS on the SQL Server 2005 and writing scripts on the VMS side to transfer the files into Windows instead. This is actually more flexible as the scripting capabilities of VMS (DCL) are far more powerful. You can then use the Foreach Loop container to iterate through the files in SQL Server 2005.

The downside is that I don't like having an FTP service running on my database server; also, this workaround requires you to have sufficient access to the mainframe to create the scripts etc. The latter is not an issue in my case as I administer both machines.

FTP from a mainframe (z/os) box

Has anyone been able to use an ftp task to pull a flat file from a z/os mainframe? The ftp task appears to want the remote file to begin with a /, which pulls you into unix system services on z/os.

Thanks!
HarryHarry,

We do not support paths that do not start with a /. Please feel free to file a bug about this.

Thanks,
Matt|||Same problem makes it impossible to pull a file off a VMS system. Ironic that in the land of the backslash, the Unix convention is mandatory ....
|||Well now, that's a big bummer. About all of my interfaces involve mainframe datasets.
|||

Will Wilson wrote:

Well now, that's a big bummer. About all of my interfaces involve mainframe datasets.

I worked around this by installing IIS on the SQL Server 2005 and writing scripts on the VMS side to transfer the files into Windows instead. This is actually more flexible as the scripting capabilities of VMS (DCL) are far more powerful. You can then use the Foreach Loop container to iterate through the files in SQL Server 2005.

The downside is that I don't like having an FTP service running on my database server; also, this workaround requires you to have sufficient access to the mainframe to create the scripts etc. The latter is not an issue in my case as I administer both machines.