Hello: Is there a way to open a connection to the mainframe and FTP a file from the mainframe to a local file? I've done it through a script I found online but when retrieving the file it's all jumbled as if it's encrypted or something. The normal process we've followed is kicking off a batch file (call_datafile.bat) with sample code below: ftp -s:C:\SCRIPT\call_datafile.txt pause This kicks off as displayed above a text file (call_datafile.txt) with commands sampled as followed: open MVSTEST1 username password get 'usr.dfile1.may11' C:\DATA\dfile1.txt pause This method has worked great! But...we're moving all these tasks and events to Integration Services and I've attempted numerous methods for retrieving this file. Any ideas from anyone would be great! If you need additional info please don't hesitate. Thanks!

Ok, I've tested inserting a Execute Process Task that kicks off an FTP file containing the commands to pull down the data. Ideally, if possible to pull down the file from the mainframe all from within the package itself and not have to trigger an external file containing commands that would be more ideal. The FTP file obviously contains the login info that becomes exposed by anyone that may open this .FTP file and see what's occurring. Any feedback or thoughts on this would be much helpful!

Use the FTP Task. Arthur My Blog

I tried the FTP task but unfortunately the RemotePath requires a / at the beginning which does not work. I've tried numerous combinations of typing in the mainframe file, login, etc...utilizing an FTP Connection Manager / Task. Perhaps I'm configuring it improperly or perhaps this could be automated to bypass requiring a forward-slash at the beginning of RemotePath. Now, I was able to code a WebClient FTP script within the package that did in fact pull data down but opening the text file up the data is possibly encrypted...looks all jumbled. (example of the jumbled output below...just a few parts of just line 1...the whole file appears like this) ðñ^ðððððððòóô^ÔÉÃÈÉÇÁÕ@ÃÁÙ@æÁ^ùòôððøóòðõ^@@@@@@@@@@@@ðKðð^@@@@@@@@@@@@

I tried the FTP task but unfortunately the RemotePath requires a / at the beginning which does not work. I've tried numerous combinations of typing in the mainframe file, login, etc...utilizing an FTP Connection Manager / Task. Perhaps I'm configuring it improperly or perhaps this could be automated to bypass requiring a forward-slash at the beginning of RemotePath. Now, I was able to code a WebClient FTP script within the package that did in fact pull data down but opening the text file up the data is possibly encrypted...looks all jumbled. (example of the jumbled output below...just a few parts of just line 1...the whole file appears like this) ðñ^ðððððððòóô^ÔÉÃÈÉÇÁÕ@ÃÁÙ@æÁ^ùòôððøóòðõ^@@@@@@@@@@@@ðKðð^@@@@@@@@@@@@

Data from MainFrame typically is EBCDIC format, perhaps you need to convert that to ASCII. Yes, the forward slash ( / ) is necessary for FTP, why there is a problem? Any errors?Arthur My Blog

Data from MainFrame typically is EBCDIC format, perhaps you need to convert that to ASCII. Yes, the forward slash ( / ) is necessary for FTP, why there is a problem? Any errors? Arthur My Blog On mainframe computers the slash is not used to access directories. They have different syntax for locating files.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/