Monday, March 26, 2012

ftp a report

What is the easiest way to ftp a reporting services report out to a ftp site ?
Any ideas greatly appreciated.
Thanks.Using ftp at command prompt:
C:\>ftp
ftp>open <FtpServerName>
ftp>user <MyUserName> then enter password if required
ftp>lcd <LocalMachineDirectory>
ftp>cd <FtpServerDirectory>
ftp>put <MyReport.rdlFileName>
ftp>close
ftp>quit
C:\>
"steve" wrote:
> What is the easiest way to ftp a reporting services report out to a ftp site ?
> Any ideas greatly appreciated.
> Thanks.|||Hi magendo_man and thanks for the reply. Have no problem with the ftp syntax
the question i should have posted is how do you do this from reporting
services? Do you create a subscription ? etc. Only see an option to email to
an address in a unique format. These reports are great and need to provide a
copy of the report to a ftp site.
Thanks
"magendo_man" wrote:
> Using ftp at command prompt:
> C:\>ftp
> ftp>open <FtpServerName>
> ftp>user <MyUserName> then enter password if required
> ftp>lcd <LocalMachineDirectory>
> ftp>cd <FtpServerDirectory>
> ftp>put <MyReport.rdlFileName>
> ftp>close
> ftp>quit
> C:\>
> "steve" wrote:
> > What is the easiest way to ftp a reporting services report out to a ftp site ?
> > Any ideas greatly appreciated.
> >
> > Thanks.|||You could get the report published as a pdf/xls/... to a file share and then
set up an ftp script as a scheduled task.
HTH,
Magendo_man
"steve" wrote:
> Hi magendo_man and thanks for the reply. Have no problem with the ftp syntax
> the question i should have posted is how do you do this from reporting
> services? Do you create a subscription ? etc. Only see an option to email to
> an address in a unique format. These reports are great and need to provide a
> copy of the report to a ftp site.
> Thanks
> "magendo_man" wrote:
> > Using ftp at command prompt:
> >
> > C:\>ftp
> >
> > ftp>open <FtpServerName>
> > ftp>user <MyUserName> then enter password if required
> > ftp>lcd <LocalMachineDirectory>
> > ftp>cd <FtpServerDirectory>
> > ftp>put <MyReport.rdlFileName>
> > ftp>close
> > ftp>quit
> >
> > C:\>
> >
> > "steve" wrote:
> >
> > > What is the easiest way to ftp a reporting services report out to a ftp site ?
> > > Any ideas greatly appreciated.
> > >
> > > Thanks.

No comments:

Post a Comment