Exporting from snapshot data

Is there anyway possible to grab a snapshot via some vb.net or c# code and
then export it to pdf, txt, etc...?Yes,
If you've created a snapshot then you can get to the snapshot via the REnder
Method on the Reporting Services' SOAP interface.
Chapter 9¾ (Our Harry Potter Themed Chapter with Voldemort Basic.NET quips)
deals with SOAP and pages 585 - 592 - should show you all the details you
need to know about how to create a snapshot via code and also how to render
it.
Peter Blackburn
Hitchhiker's Guide to SQL Server 2000 Reporting Services
http://www.sqlreportingservices.net
"Mike H" <Mike H@.discussions.microsoft.com> wrote in message
news:62F37D51-6862-415C-9C87-FE82685FC6D3@.microsoft.com...
> Is there anyway possible to grab a snapshot via some vb.net or c# code and
> then export it to pdf, txt, etc...?sql

Exporting diagram

When using the DTS to copy a db from my local MSSQL to the remote server (connecting via IP address) everything is copied ok except the diagram laying out the relations.
The table relations *are* copied because the damn thing works as expected also on the remote server.

I figured out that the diagrams are saved in the sysfile 'dtproperties' but when copying using the DTS query tool from local to remote this table is not visible.

I need to remove some relations on certain tables when bulk loading new data and was just wondering how I got to copy the diagram (as opposed to creating a new diagram on the remote server and adding relations manually).

Thanks a lot for any ideas,
Nielsdtproperties doesnt show up in the query builder. just write it by hand "select * from dtproperties"
also, if you dont create the destination file/object (i.e. flat text file) prior to running this it will complain about an object not being found. for instance if you name your destination file dtproperties.txt in the exporter but it doesnt exist it will complain -- at least it did for me.

Export/Import via web

Scenario:
- W2k server sp4 / sql server 2k sp4 box.
- firewall with only port 80 opened.
I have to:
Query data from remote server to export into local server.
I would like to do it via ASP/IIS in one step.
How can I do it?
Regards.
Gibe si fatto passare perch Rossi dietro come una purga, prima o
poi una cagata te la fa fare...!Hi
I am not an ASP expert and you may get a better reply in a internet
programming newsgroup.
I don't know of any way to do this in one step! Some componenets will let
you save the contents to file (such as an excel spreadsheet) but it is a two
stage process to select/insert the data and then save it. Other two process
would be to have scheduled jobs or DTS packages to create the files and then
allow the user to download them.
John
"Fabri" wrote:

> Scenario:
>
> - W2k server sp4 / sql server 2k sp4 box.
> - firewall with only port 80 opened.
>
> I have to:
> Query data from remote server to export into local server.
> I would like to do it via ASP/IIS in one step.
> How can I do it?
> Regards.
> --
> Gibe si è fatto passare perchè Rossi dietro è come una purga, prima o
> poi una cagata te la fa fare...!
>

Export/Import ASP.NET Membership data

Greetings All,
I need to export/import the ASP.NET Membership data which is installed in my database via aspnet_regsql.exe. Does anyone have the Cliff notes on how to do this?

Thanks in advance.
Since this is just a set of standard SQL Server tables, you should be able to use any SSIS tool or technique to do this. The import/export wizard in SQL Server Management Studio should work just fine.|||That's what I was hoping, but unfortunetly that is not the case.

When I run the package created with the wizard specifying only the following tables:

aspnet_Users
aspnet_Applications
aspnet_Roles
aspnet_UsersInRoles
aspnet_Membership
aspnet_SchemaVersions

I get the following output:

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.
Information: 0x402090DF at Data Flow Task, Destination 1 - aspnet_Membership [132]: The final commit for the data insertion has started.
Information: 0x402090DF at Data Flow Task, Destination 3 - aspnet_SchemaVersions [274]: The final commit for the data insertion has started.
Information: 0x402090DF at Data Flow Task, Destination - aspnet_Applications [28]: The final commit for the data insertion has started.
Information: 0x402090DF at Data Flow Task, Destination 2 - aspnet_Roles [222]: The final commit for the data insertion has started.
Information: 0x402090DF at Data Flow Task, Destination 4 - aspnet_Users [334]: The final commit for the data insertion has started.
Error: 0xC0202009 at Data Flow Task, Destination 3 - aspnet_SchemaVersions [274]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK__aspnet_SchemaVer__4316F928'. Cannot insert duplicate key in object 'dbo.aspnet_SchemaVersions'.".
Error: 0xC0202009 at Data Flow Task, Destination 2 - aspnet_Roles [222]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK__aspnet_Ro__Appli__24E777C3". The conflict occurred in database "CommonPassDB", table "dbo.aspnet_Applications", column 'ApplicationId'.".
Information: 0x402090E0 at Data Flow Task, Destination 3 - aspnet_SchemaVersions [274]: The final commit for the data insertion has ended.
Information: 0x402090E0 at Data Flow Task, Destination 2 - aspnet_Roles [222]: The final commit for the data insertion has ended.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination 2 - aspnet_Roles" (222) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination 3 - aspnet_SchemaVersions" (274) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread2" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread3" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC0202009 at Data Flow Task, Destination - aspnet_Applications [28]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of UNIQUE KEY constraint 'UQ__aspnet_Applicati__3E52440B'. Cannot insert duplicate key in object 'dbo.aspnet_Applications'.".
Error: 0xC0202009 at Data Flow Task, Destination 4 - aspnet_Users [334]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK__aspnet_Us__Appli__25DB9BFC". The conflict occurred in database "CommonPassDB", table "dbo.aspnet_Applications", column 'ApplicationId'.".
Information: 0x402090E0 at Data Flow Task, Destination 4 - aspnet_Users [334]: The final commit for the data insertion has ended.
Information: 0x402090E0 at Data Flow Task, Destination - aspnet_Applications [28]: The final commit for the data insertion has ended.
Error: 0xC0202009 at Data Flow Task, Destination 1 - aspnet_Membership [132]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK__aspnet_Me__Appli__178D7CA5". The conflict occurred in database "CommonPassDB", table "dbo.aspnet_Applications", column 'ApplicationId'.".
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination 4 - aspnet_Users" (334) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Information: 0x402090E0 at Data Flow Task, Destination 1 - aspnet_Membership [132]: The final commit for the data insertion has ended.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - aspnet_Applications" (28) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread4" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination 1 - aspnet_Membership" (132) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread1" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DF at Data Flow Task, Destination 5 - aspnet_UsersInRoles [387]: The final commit for the data insertion has started.
Information: 0x402090E0 at Data Flow Task, Destination 5 - aspnet_UsersInRoles [387]: The final commit for the data insertion has ended.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination - aspnet_Applications" (28)" wrote 1 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination 1 - aspnet_Membership" (132)" wrote 1 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination 2 - aspnet_Roles" (222)" wrote 1 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination 3 - aspnet_SchemaVersions" (274)" wrote 3 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination 4 - aspnet_Users" (334)" wrote 1 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination 5 - aspnet_UsersInRoles" (387)" wrote 0 rows.
Task failed: Data Flow Task
SSIS package "Package1.dtsx" finished: Failure.
The program '[5340] Package1.dtsx: DTS' has exited with code 0 (0x0).

Has anyone ever tried this before?

Thanks.
|||You need to ensure that you're running the packages in the correct order, so that the foreign key constraints aren't violated.|||The wizard creates a single package containing a single Data Flow Task. Inside the Data Flow Task is a pair of OLEDB Source and Destination Data Flow Sources. How do I control the order in which the OLEDB "pairs" execute?

Must I break each one of these out into its own Data Flow Task?
|||Yes. This default configuraion is running them in parallel; you need them to run in a specific serial order based on the FKs defined in the database, which cannot be done in a single data flow.|||Ok, thanks. That did it.

I appreciate your help.

|||Thanks for the feedback - good luck!

export to excel, file not found

With sp1 installed, when a user exports a chart to excel via url
(ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this up
as a link on the report) everything works when the user has office xp
installed, but with office 2000, the user can only use the save as feature,
and then open the excel rendered chart. If the user selects "open" from the
dialog prompt, they get an error:
C:\Documents and Settings\User\Local Settings\Temporary Internet
Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
spelling of the name ...
Is this the result of a browser setting, or server security on my end?
Thanks for any help.Have you installed Reporting Services SP1 on the server? This is required
for Office 2000 support.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JeffW" <JeffW@.discussions.microsoft.com> wrote in message
news:396BF27F-0526-43BC-BB78-D59DDE5B6058@.microsoft.com...
> With sp1 installed, when a user exports a chart to excel via url
> (ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this
> up
> as a link on the report) everything works when the user has office xp
> installed, but with office 2000, the user can only use the save as
> feature,
> and then open the excel rendered chart. If the user selects "open" from
> the
> dialog prompt, they get an error:
> C:\Documents and Settings\User\Local Settings\Temporary Internet
> Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
> spelling of the name ...
> Is this the result of a browser setting, or server security on my end?
> Thanks for any help.|||Brian,
Thanks for your reply.
I have installed sp1 on the server, and verified that both my dev
environment and server are running version 8.00.878.00. Also, the excel
export does work, when the user chooses to save the file and then open it
(office 2000). It only fails when they try to open the exported chart
directly from the dialog that says "You are downloading the file ... Would
you like to open the file or save it to your computer ...". And it only
happens when to office 2000 or less users.
After installing sp1 on the server, I did not reboot or anything, but
confirmed that the version matched my dev environment that also has sp1.
Should I create the report from scratch or are there files/timestamps I
should be looking for on the server related to the renderer/exporter?
Thanks,
JeffW
"Brian Welcker [MSFT]" wrote:
> Have you installed Reporting Services SP1 on the server? This is required
> for Office 2000 support.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JeffW" <JeffW@.discussions.microsoft.com> wrote in message
> news:396BF27F-0526-43BC-BB78-D59DDE5B6058@.microsoft.com...
> > With sp1 installed, when a user exports a chart to excel via url
> > (ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this
> > up
> > as a link on the report) everything works when the user has office xp
> > installed, but with office 2000, the user can only use the save as
> > feature,
> > and then open the excel rendered chart. If the user selects "open" from
> > the
> > dialog prompt, they get an error:
> >
> > C:\Documents and Settings\User\Local Settings\Temporary Internet
> > Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
> > spelling of the name ...
> >
> > Is this the result of a browser setting, or server security on my end?
> >
> > Thanks for any help.
>
>

Export to Excel

Is there some way to name the worksheet that is generated when you export
from Reporting Services via Excel?
--
Abe CherianAs indicated in previous newsgroup threads, this is not supported in RS
2000. It is on the wishlist for inclusion in a future release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Abe Cherian" <AbeCherian@.discussions.microsoft.com> wrote in message
news:699485B4-A8F1-4BC3-A1DE-036978539290@.microsoft.com...
> Is there some way to name the worksheet that is generated when you export
> from Reporting Services via Excel?
> --
> Abe Cherian