Importing subscriptions from RS 2000 to RS 2005

Hi, I am moving from SQL server 2000 to SQL server 2005. I'am also moving to the new Reporting services 2005. There are almost 400 reports and like 100 subscriptions under the actual configuration. I have imported the reports but I don't know how to recreate the subscriptions.

Any ideas?

Thanks,
Alejandro Gutierrez.

It sounds like to did not upgrade, but you are rather trying to migrate the contents to RS 2005. You could move the subscriptions for instance by making SOAP calls to retrieve the settings from one server and apply them on the other server.

A tool I found quite useful for performing this kind of job is Jasper Smith's RS Scripter: http://www.sqldbatips.com/showarticle.asp?ID=62

-- Robert

|||

Yes, I'm migrinting to another server. That tool seems pretty cool. I'm going to give it a try. Thanks a bunch !!!

Alejandro.l

sql

Importing report content direct to SQL Server for testing purposes

Hi

I have what seems a simple requirement. We want to import the contents of a SQL Server 2005 Reporting Services report into a SQL Server 2005 database, in order to perform some checks on reports displayed to users. Is there an easy way to achieve this? XML would seem appropriate, but I can't find a step-by-step guide on how to achieve this. Any pointers/suggestions would be appreciated.

Thanks

Neil

Hey Neil,

If you export the report to CSV, it should be fairly easy to import that data back into your database using Integration Services.

Jarret

|||

Hi Jarret

Thanks for the CSV idea. However the reports are fairly complex, with a number of totals, sub-reports, etc, that would be difficult to make sense of with CSV. I guess that XML would enable the meaning of each value to be specified along with the value, and hence loaded more easily for subsequent checking. However, since I simply wanted to integrate two Microsoft products I was hoping there was an easy way to capture Reporting Services output and import into SQL Server. Could well be that I'm missing something obvious though - hence my request!

Thanks

Neil

|||

We have found a workable solution.

Create report subscriptions in Reporting Services to export the report content as XML.sql

Importing from Crystal Report 7 to Reporting Services

Dear all,

I was wondering if I can import reports made by crystal report 7 to Reporting Services 2000.

Thank you.This one isn't free, but may be worth a try for $5-$15.
Another consulting company, Hitachi, provides services to do this. See Post.
There is no built-in way to convert reports.

Importing data into SQL Server 2005 via ODBC

Hi

I've got an Ingres database of some 200 tables which I need to import
every night into SQL Server 2005 for use by Reporting Services. Most
of the tables will come across unchanged (a few need massaging to
handle time intervals correctly), but the Import Wizard only seems to
want to import one table (or more accurately query) at a time. I seem
to remember the old 2000 Import Wizard handled multiple tables - is
there any way of processing multiple tables in 2005, or must I resign
myself to writing 200 import packages in SSIS.

Chloe Crowder
The British LibraryChloe C (chloe@.mcrowdd.plus.com) writes:

Quote:

Originally Posted by

I've got an Ingres database of some 200 tables which I need to import
every night into SQL Server 2005 for use by Reporting Services. Most
of the tables will come across unchanged (a few need massaging to
handle time intervals correctly), but the Import Wizard only seems to
want to import one table (or more accurately query) at a time. I seem
to remember the old 2000 Import Wizard handled multiple tables - is
there any way of processing multiple tables in 2005, or must I resign
myself to writing 200 import packages in SSIS.

Are you looking at the Import Wizard in Mgmt Studio? I think you should
look into SQL Server Integration Services, for which you can create
packages in Business Intelligence Development Studio. (Although that is
as much I know about SSIS.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi Chloe,

Just had to do this today and it seems to work fine (although importing
multiple Excel sheets to multiple tables). After you select the Source and
Destination, there is a screen that asks to "Copy data from one or more
tables/views" or "Query" (not sure about the exact wording of the options
but something close). Then you can do mapping to destination tables/columns.
The last step is to execute or save as SSIS package.

If you do not see that option, check if you have the latest service pack. It
will be worth testing with SQL Server as Source, just to see if it has to do
with the driver for the source (I am confident you can import multiple
tables when the source is SQL Server).

HTH,

Plamen Ratchev
http://www.SQLStudio.com|||On Tue, 27 Nov 2007 19:13:10 -0500, "Plamen Ratchev"
<Plamen@.SQLStudio.comwrote:

Quote:

Originally Posted by

>Hi Chloe,
>
>Just had to do this today and it seems to work fine (although importing
>multiple Excel sheets to multiple tables). After you select the Source and
>Destination, there is a screen that asks to "Copy data from one or more
>tables/views" or "Query" (not sure about the exact wording of the options
>but something close). Then you can do mapping to destination tables/columns.
>The last step is to execute or save as SSIS package.
>
>If you do not see that option, check if you have the latest service pack. It
>will be worth testing with SQL Server as Source, just to see if it has to do
>with the driver for the source (I am confident you can import multiple
>tables when the source is SQL Server).
>
>HTH,
>
>Plamen Ratchev
>http://www.SQLStudio.com
>

Plamen

thanks for this. Importing multiple tables works well from SQL Server,
but with the Ingres server as the source the Copy data from one or
more tables/view option is greyed out, leaving only the option of a
single select statement in a query.

Ah well, I'll do it the hard way.

Chloe|||On Tue, 27 Nov 2007 22:59:18 +0000 (UTC), Erland Sommarskog
<esquel@.sommarskog.sewrote:

Quote:

Originally Posted by

>Chloe C (chloe@.mcrowdd.plus.com) writes:

Quote:

Originally Posted by

>I've got an Ingres database of some 200 tables which I need to import
>every night into SQL Server 2005 for use by Reporting Services. Most
>of the tables will come across unchanged (a few need massaging to
>handle time intervals correctly), but the Import Wizard only seems to
>want to import one table (or more accurately query) at a time. I seem
>to remember the old 2000 Import Wizard handled multiple tables - is
>there any way of processing multiple tables in 2005, or must I resign
>myself to writing 200 import packages in SSIS.

>
>Are you looking at the Import Wizard in Mgmt Studio? I think you should
>look into SQL Server Integration Services, for which you can create
>packages in Business Intelligence Development Studio. (Although that is
>as much I know about SSIS.)

Erland

I was rather hoping to, in effect, automate the creation of my SSIS
package with the Import Wizard, otherwise I need to do each import as
a separate task in SSIS.

Ah well, do it the hard way...

Chloe

Importing data from Movex

I am looking to replicate data from a Movex system into an SQL 2005

database for reporting and analysis purposes. Does anyone have any

ideas/tips on how to go about automating this process? With scripts?

Thanks in advance.

Dan E.

You may try your question at the MSDN forum: SQL Server Reporting Services (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1).

|||
Thanks.

Importing Crystal Reports into Reporting Services

I see that you can import Access reports into Reporting Services. Is that
an add-in or something that will allow me to import Crystal Reports reports
into Reporting Services?
Any help is greatly appreciated.Not out of the box, but there are companies, develop tools for the same.
Goolge and see you will get some tools.
Amarnath
"Greg Smith" wrote:
> I see that you can import Access reports into Reporting Services. Is that
> an add-in or something that will allow me to import Crystal Reports reports
> into Reporting Services?
> Any help is greatly appreciated.
>
>

Importing Active Reports to SQL 2005 reporting services

Does anyone know of any documentation that shows a easy way to import

Crystal reports / Active reports to SQL 2005 reporting services?

Thanks

Unfortunately, there is no easy way to do this: There are no wizards, etc. in SSRS (or 3rd party, as I recall) that will do the work for you. There are some services (Hitachi consulting, etc.) that will refactor the reports for you, but this obviously will cost some $$'s you probably don't want to spend.

Importing Access 2002 into Reporting Services

Getting the following error when trying to import an Access 2002 database into Microsoft Reporting Services:
--The given path's format is not supported--
Please advise if you know what this is referring to.R U Using URL or local path ?|||Originally posted by Ben Mansouri
R U Using URL or local path ?

local path, should I use URL?

importing a pdf file

I have a business objects report that I would like to set up in reporting
services. I'm wondering if there is a way to import or display a link to a
.pdf file in reporting services.
Any ideas?
ThanksThere's no way to "import" PDFs, but you can include hyperlinks to external
PDF documents in Reporting Services' reports.
Best,
-Chris
SQL Server Reporting Services
"beeyule" <beeyule@.discussions.microsoft.com> wrote in message
news:82D55264-C23D-41D5-A809-4A838C334518@.microsoft.com...
>I have a business objects report that I would like to set up in reporting
> services. I'm wondering if there is a way to import or display a link to
> a
> .pdf file in reporting services.
> Any ideas?
> Thanks