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.

From one server to another

Bear in mind that I am just a beginner and ingorance is bliss!

Two questions

1. Could someone tell me the most efficient (and easiest) way to move summurize and move data from one db on server A to another db on serverB. This process needs to run on an hourly basis.

If they were on the same server I would create a job under Management and use this code.

INSERT INTO tblNewTable
SELECT SUM(thiscolumn), SUM(thatcolumn), SUM(ETC)
FROM tblOld
WHERE columnDateTime > (SELECT MAX(columnDateTime) FROM tblNewTable)
GROUP BY DATEPART(hh, columnDate), Line, Shift

My problem is I THINK that you have to script the connection between the two severs and I dont know how to do this.

2. In tblNewTable, the data is used to report machine efficency for each line and shift. The problem is that the 3rd shift begins at 11PM, but its production is applied to the following day. I have used

WHERE columnDateTime >= DATEADD(hh, -1, StartDate) AND columnDateTime <= DATEADD(hh, -1, EndDate)

and leave off the GROUP BY columnDateTime to get the shift's data together.

Is it possible for 11 to 12 PM to be brought in as the following days date?

Thanks,
LeeQ1 [Do I have to script] the connection between the two severs? and I how [do I] do this.
A1 You might want to use linked servers (you could use osql if you really want to script a connection).

Q2 Is it possible for 11 to 12 PM to be brought in as the following days date?
A2 Yes, but you will need to code the logic to do so. (case and / or if statements, etc.)