get a file From FTP site

I have to download a file from a ftp site using either SQL/T-Sql or ActiveX script. I'm using SQL Server 2000. Please help
Thanks in advancehttp://www.nigelrivett.net/s_ftp_PutFile.html

thanks to nigelrivett|||I wanted to say that :).

Generate report that link to analysis services

Is there any samples to download that show how to create matrix report that
link to microsoft sql server 2000 analysis services? I understand that user
can use the mdx query (Analysis Services) to generate a report..But is there
an easy way just link to datasource (cube) that is created in analysis
services (same as table)? For example, I have create a cube name sales in
the analysis services and i try to create report by using the report wizard,
build a query at reporting services by using sql statement "select * from
sales"... It give me a funny field name which are found at report wizard
(under Design the table stage).
Thank You.The current release of SQL Server Reporting Services 2000 allows you to
execute MDX queries against Analysis Services cubes. A very good MSDN
article with samples about the integration of RS 2000 and AS 2000 is
provided at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
A graphical query designer for creating MDX queries will be available in the
RS 2005 release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"alvin" <alvinleo@.time.net.my> wrote in message
news:uxvnmp1XEHA.2940@.TK2MSFTNGP09.phx.gbl...
> Is there any samples to download that show how to create matrix report
that
> link to microsoft sql server 2000 analysis services? I understand that
user
> can use the mdx query (Analysis Services) to generate a report..But is
there
> an easy way just link to datasource (cube) that is created in analysis
> services (same as table)? For example, I have create a cube name sales in
> the analysis services and i try to create report by using the report
wizard,
> build a query at reporting services by using sql statement "select * from
> sales"... It give me a funny field name which are found at report wizard
> (under Design the table stage).
> Thank You.
>