A few ways we have done it using a Run Process from Windows to AIX (typically) are:
- Use a SSIS package developed in MSSQL. One step creates the file and another step uses the built-in FTP connector (I can't remember if that is the official name) to transfer the file. - Use PSCP or PSFTP that comes with PuTTY. http://the.earth.li/~sgtatham/putty/0.63/htmldoc/Chapter5.html#pscp http://the.earth.li/~sgtatham/putty/0.63/htmldoc/Chapter6.html#psftp Jason On Wed, Dec 18, 2013 at 7:58 AM, pritch <pri...@ptd.net> wrote: > Carol, > > I create files on my server (Solaris) from a filter by issuing a 'Run > Process' action. The action is something like > > echo "$field$" > $File Path$ > > and then > > echo "$field" >> $File Path$ > > What I'm echoing (the $field$) is a bit more complex than that to account > for Carriage Returns. Once I have the file built, I issue a cmd to the > server to zip it along with some attachments and then bring it back into an > attachment which is then emailed out. So while I don't transfer it to a > mainframe, the building part may be helpful to you. > > Others on the arslist may have some slicker ideas - admittedly, mine is a > bit crude. > > ----- Original Message ----- > From: "Carol Carnevali" <carol.carnev...@broadridge.com> > To: arslist@ARSLIST.ORG > Sent: Monday, December 16, 2013 3:27:26 PM > Subject: Re: How to transport files to a mainframe > > Thanks Joel, but how do I use a filter to create a report and save it to a > file? That's the part I'm missing. > > Thanks. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"