Accessing Delivery Extension UI WebControls

hi,
We are developing a custom web application that will interact with the
Reporting Services web service (instead of using the ReportManager). I need
to manage subscriptions from my custom web app just like ReportManager does.
I would like to programmatically access the web controls located in each
extension dll (e-mail, fileshare, or my own custom dlls) used to gather
information from the client instead of having to write new ones. I know the
ReportManager accesses these objects (for example, the
PrinterDeliveryUIProvider in the printer delivery sample), so there must be a
way to do this. (Reflection?)
I couldn't find any helpful documentation (might have missed something), and
wondered if anyone knew how the best way to go about this.
Thanks,
MattThe Report Manager obtains the list of the registered UI controls from the
<DeliveryUI> element in the RSWebApplication.config file. Then, it proceeds
by loading dynamically the user control presumably by calling LoadControl().
Since the UI controls implement ISubscriptionBaseUIUserControl the Report
Manager knows how to manipulate them in a standard fashion.
You may find my custom Web Service delivery extension (included in the book
source code) useful to understand how the UI controls work.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"mshumaker" <mshumaker@.discussions.microsoft.com> wrote in message
news:14595C36-8130-481F-8DC9-7C356DF66314@.microsoft.com...
> hi,
> We are developing a custom web application that will interact with the
> Reporting Services web service (instead of using the ReportManager). I
need
> to manage subscriptions from my custom web app just like ReportManager
does.
> I would like to programmatically access the web controls located in each
> extension dll (e-mail, fileshare, or my own custom dlls) used to gather
> information from the client instead of having to write new ones. I know
the
> ReportManager accesses these objects (for example, the
> PrinterDeliveryUIProvider in the printer delivery sample), so there must
be a
> way to do this. (Reflection?)
> I couldn't find any helpful documentation (might have missed something),
and
> wondered if anyone knew how the best way to go about this.
> Thanks,
> Matt|||Ah, that would be the link I was looking for. I focused on obtaining the
info straight from the ReportServer and didn't think of using my own config
file. And after the time I've already spent with the config files while
getting my custom delivery extension to work...
I will also look into the LoadControl() method.
Thanks for your help.
Matt
"Teo Lachev [MVP]" wrote:
> The Report Manager obtains the list of the registered UI controls from the
> <DeliveryUI> element in the RSWebApplication.config file. Then, it proceeds
> by loading dynamically the user control presumably by calling LoadControl().
> Since the UI controls implement ISubscriptionBaseUIUserControl the Report
> Manager knows how to manipulate them in a standard fashion.
> You may find my custom Web Service delivery extension (included in the book
> source code) useful to understand how the UI controls work.
> --
> Hope this helps.
>|||LoadControl() won't work - it loads a UserControl where a control used for a
delivery extension UI is a WebControl.
I'll look into this more - maybe try loading it with reflection.
"mshumaker" wrote:
> Ah, that would be the link I was looking for. I focused on obtaining the
> info straight from the ReportServer and didn't think of using my own config
> file. And after the time I've already spent with the config files while
> getting my custom delivery extension to work...
> I will also look into the LoadControl() method.
> Thanks for your help.
> Matt
>
> "Teo Lachev [MVP]" wrote:
> > The Report Manager obtains the list of the registered UI controls from the
> > <DeliveryUI> element in the RSWebApplication.config file. Then, it proceeds
> > by loading dynamically the user control presumably by calling LoadControl().
> > Since the UI controls implement ISubscriptionBaseUIUserControl the Report
> > Manager knows how to manipulate them in a standard fashion.
> >
> > You may find my custom Web Service delivery extension (included in the book
> > source code) useful to understand how the UI controls work.
> >
> > --
> > Hope this helps.
> >
>|||My bad :-)
Than, it is probably dynamically loading the assembly using Load or LoadFrom
and adding the control to a placeholder, e.g.
PlaceHolder1.Controls.Add(ctrl);
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"mshumaker" <mshumaker@.discussions.microsoft.com> wrote in message
news:01BF60A4-B199-4A2C-B494-5741ADAD650E@.microsoft.com...
> LoadControl() won't work - it loads a UserControl where a control used for
a
> delivery extension UI is a WebControl.
> I'll look into this more - maybe try loading it with reflection.
> "mshumaker" wrote:
> >
> > Ah, that would be the link I was looking for. I focused on obtaining
the
> > info straight from the ReportServer and didn't think of using my own
config
> > file. And after the time I've already spent with the config files while
> > getting my custom delivery extension to work...
> >
> > I will also look into the LoadControl() method.
> >
> > Thanks for your help.
> > Matt
> >
> >
> > "Teo Lachev [MVP]" wrote:
> >
> > > The Report Manager obtains the list of the registered UI controls from
the
> > > <DeliveryUI> element in the RSWebApplication.config file. Then, it
proceeds
> > > by loading dynamically the user control presumably by calling
LoadControl().
> > > Since the UI controls implement ISubscriptionBaseUIUserControl the
Report
> > > Manager knows how to manipulate them in a standard fashion.
> > >
> > > You may find my custom Web Service delivery extension (included in the
book
> > > source code) useful to understand how the UI controls work.
> > >
> > > --
> > > Hope this helps.
> > >
> >

Accessing Cube from Excel 2003

Analysis services Cube is created using SQL Server 2005 (CTP June). Server is in Prod domain.
There is no problems accessing and playing with Cube in the same box or within PROD domain.

While trying to access Cube from excel 2003 from a computer in other domain QUAL gives the following error

"an error was encountered in the transportation layer"

Any suggestions ?

I'm not exactly sure how IE Security settings interact with PTS, but your problem is making me think of the 'Access Data Sources across Domains' option in IE / Tools / Options / Security / Custom Level / Misc.

Is that option enabled?

Accessing Cube from Excel 2003

Analysis services Cube is created using SQL Server 2005 (CTP June). Server is in Prod domain.
There is no problems accessing and playing with Cube in the same box or within PROD domain.

While trying to access Cube from excel 2003 from a computer in other domain QUAL gives the following error

"an error was encountered in the transportation layer"

Any suggestions ?

I'm not exactly sure how IE Security settings interact with PTS, but your problem is making me think of the 'Access Data Sources across Domains' option in IE / Tools / Options / Security / Custom Level / Misc.

Is that option enabled?

Accessing AS400 Data

I've been trying to use the integrations services to access AS400 data with almost no success. Any suggestions or help you can give me would be appreciated. Some of the issues I can't make sense of are the following.

1. When I set up an OLEDB data source for the AS400 (using IBM's Client Access provider) I always get a warning message about "Cannot retrieve the column code page information from the OLEDB provider". What do I do about this warning?

2. If the oledb datasource is a table I can sometimes get it to work (though it seems very slow) but if I make the source a sql query it always fails in the first step with an OLEDB error. Any ideas about where to look for the problem?

Below is a sample outlook log from a failure. The only change from a previous example which success was that I changed the Access Mode from OpenRowSet to SQL Command and replace the table name with a sql statement select all the fields in the table.

SSIS package "Package.dtsx" starting.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

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

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

Information: 0x402090DC at Data Flow Task, Flat File Destination [4320]: The processing of file "c:\txpfstat.txt" has started.

Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning

Error: 0xC0202009 at Data Flow Task, OLE DB Source [3820]: An OLE DB error has occurred. Error code: 0x80040E00

Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "OLE DB Source" (3820) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.

Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.

Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning

Information: 0x402090DD at Data Flow Task, Flat File Destination [4320]: The processing of file "c:\txpfstat.txt" has ended.

Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning

Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Flat File Destination" (4320)" wrote 0 rows.

Task failed: Data Flow Task

Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SSIS package "Package.dtsx" finished: Failure.

1. The warning is expected, you'll just need to set the "DefaultCodePage" property at your OLEDBSource to the code page you want to use for your string columns, then you can safely ignore it.
2. The fatal error is 0x80040E00, which means "Invalid Accessor", it's raised from the provider rather than from SSIS Source adapter. You may need to double check the SqlCommand you used in the OLEDBSource to see whther that's in good grammar. I tried several cases to switch from OpenRowSet to SqlCommand when connecting to a AS400 DB2 server, I see no problem (I am using the MS OLEDB provider for DB2 though).

Thanks|||1. I don't really understand code pages so I don't know how to set the DefaultCodePage property or what value to set it to. But since the data comes through okay when using OpenRowSet I guess I can just ignore the warning.

2. The SqlCommand is trivial (e.g. "select * from taxdta.txpfstat") so I'm sure the grammer is fine. Certainly the parser within SSIS thinks it fine.

Can anyone else test whether or not SSIS beta works on SQL commands using the IBM Client Access OLEDB data provider? I don't have access to the Microsoft provider to use that instead.

I'm not trying to do anything fancy here just copy entire tables (including creating the table on SQL Server) from the AS400 to SQL server without adversely impacting AS400 producution. Perhaps someone can suggest a better solution besides SSIS for copying from the AS400 to SQL Server.|||I am having the exact same problem trying to transfer data from a PeopleSoft/Oracle database (not on IBM) to a SQL 2005 database. The same transfer works fine in SQL 2000. Any help would be greatly appreciated. The code page that shows on the data source is 1252 and the locale id is English (United States). My SQL statement parses without errors and I can preview the first 200 rows of the query.|||Bill,

Did you get this resolved. Running into the same issue in accessing tables on the iSeries?

thanks,

Guido|||Anyone had any luck with this?

I can get it to work on my dev pc, but not on my server ...

pc = windows xp sp2
server = windows 2003 sp1

both using Client Access v5r3m0...|||I have the exact same problem... |||We are talking about this in two seperate threads...;) post the link below in case someone here missed the other one which contains more insights on the issue
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=107266

Thanks
Wenyang|||I have almost the same issue. My problem is, I can connect to AS400 without problem using the DTS but (now here comes) when I use this DTS in a Job Schedule the job never ends, I have no errors, no warning, nothing. The first time I stopped the Job 21 hours after it started.
I did the test to make a connection to the sql and send it to a flat file, not a single problem. As soon as I change the connection to the 400 then I have the problem. And as I said before, if I run the DTS manually it runs fine. I'm using September CTP and IBM Client Access V5R1M0 w/ sp SI11806.

If somebody have any idea I appreciate

Thanks,

Arty|||Hi Artiy,

i have had the same problem with the job sceduler but fixed it. The reason is this:
If you are running the dts by yourself then you always have to login to as400. Once you have done your account informations are cached until you log out.
The jobsceduler does not login with the credentials of your ODBC DSN. To fix it you have to create an account on your PC/Server and the as400 which has the same name and the same password. Then use this user for the DTS-Task.

checkity

Accessing AS400 Data

I've been trying to use the integrations services to access AS400 data with almost no success. Any suggestions or help you can give me would be appreciated. Some of the issues I can't make sense of are the following.

1. When I set up an OLEDB data source for the AS400 (using IBM's Client Access provider) I always get a warning message about "Cannot retrieve the column code page information from the OLEDB provider". What do I do about this warning?

2. If the oledb datasource is a table I can sometimes get it to work (though it seems very slow) but if I make the source a sql query it always fails in the first step with an OLEDB error. Any ideas about where to look for the problem?

Below is a sample outlook log from a failure. The only change from a previous example which success was that I changed the Access Mode from OpenRowSet to SQL Command and replace the table name with a sql statement select all the fields in the table.

SSIS package "Package.dtsx" starting.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

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

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

Information: 0x402090DC at Data Flow Task, Flat File Destination [4320]: The processing of file "c:\txpfstat.txt" has started.

Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning

Error: 0xC0202009 at Data Flow Task, OLE DB Source [3820]: An OLE DB error has occurred. Error code: 0x80040E00

Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "OLE DB Source" (3820) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.

Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.

Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning

Information: 0x402090DD at Data Flow Task, Flat File Destination [4320]: The processing of file "c:\txpfstat.txt" has ended.

Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning

Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Flat File Destination" (4320)" wrote 0 rows.

Task failed: Data Flow Task

Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SSIS package "Package.dtsx" finished: Failure.

1. The warning is expected, you'll just need to set the "DefaultCodePage" property at your OLEDBSource to the code page you want to use for your string columns, then you can safely ignore it.
2. The fatal error is 0x80040E00, which means "Invalid Accessor", it's raised from the provider rather than from SSIS Source adapter. You may need to double check the SqlCommand you used in the OLEDBSource to see whther that's in good grammar. I tried several cases to switch from OpenRowSet to SqlCommand when connecting to a AS400 DB2 server, I see no problem (I am using the MS OLEDB provider for DB2 though).

Thanks|||1. I don't really understand code pages so I don't know how to set the DefaultCodePage property or what value to set it to. But since the data comes through okay when using OpenRowSet I guess I can just ignore the warning.

2. The SqlCommand is trivial (e.g. "select * from taxdta.txpfstat") so I'm sure the grammer is fine. Certainly the parser within SSIS thinks it fine.

Can anyone else test whether or not SSIS beta works on SQL commands using the IBM Client Access OLEDB data provider? I don't have access to the Microsoft provider to use that instead.

I'm not trying to do anything fancy here just copy entire tables (including creating the table on SQL Server) from the AS400 to SQL server without adversely impacting AS400 producution. Perhaps someone can suggest a better solution besides SSIS for copying from the AS400 to SQL Server.|||I am having the exact same problem trying to transfer data from a PeopleSoft/Oracle database (not on IBM) to a SQL 2005 database. The same transfer works fine in SQL 2000. Any help would be greatly appreciated. The code page that shows on the data source is 1252 and the locale id is English (United States). My SQL statement parses without errors and I can preview the first 200 rows of the query.|||Bill,

Did you get this resolved. Running into the same issue in accessing tables on the iSeries?

thanks,

Guido|||Anyone had any luck with this?

I can get it to work on my dev pc, but not on my server ...

pc = windows xp sp2
server = windows 2003 sp1

both using Client Access v5r3m0...|||I have the exact same problem... |||We are talking about this in two seperate threads...;) post the link below in case someone here missed the other one which contains more insights on the issue
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=107266

Thanks
Wenyang|||I have almost the same issue. My problem is, I can connect to AS400 without problem using the DTS but (now here comes) when I use this DTS in a Job Schedule the job never ends, I have no errors, no warning, nothing. The first time I stopped the Job 21 hours after it started.
I did the test to make a connection to the sql and send it to a flat file, not a single problem. As soon as I change the connection to the 400 then I have the problem. And as I said before, if I run the DTS manually it runs fine. I'm using September CTP and IBM Client Access V5R1M0 w/ sp SI11806.

If somebody have any idea I appreciate

Thanks,

Arty|||Hi Artiy,

i have had the same problem with the job sceduler but fixed it. The reason is this:
If you are running the dts by yourself then you always have to login to as400. Once you have done your account informations are cached until you log out.
The jobsceduler does not login with the credentials of your ODBC DSN. To fix it you have to create an account on your PC/Server and the as400 which has the same name and the same password. Then use this user for the DTS-Task.

checkity

Accessing AS400 Data

I've been trying to use the integrations services to access AS400 data with almost no success. Any suggestions or help you can give me would be appreciated. Some of the issues I can't make sense of are the following.

1. When I set up an OLEDB data source for the AS400 (using IBM's Client Access provider) I always get a warning message about "Cannot retrieve the column code page information from the OLEDB provider". What do I do about this warning?

2. If the oledb datasource is a table I can sometimes get it to work (though it seems very slow) but if I make the source a sql query it always fails in the first step with an OLEDB error. Any ideas about where to look for the problem?

Below is a sample outlook log from a failure. The only change from a previous example which success was that I changed the Access Mode from OpenRowSet to SQL Command and replace the table name with a sql statement select all the fields in the table.

SSIS package "Package.dtsx" starting.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

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

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

Information: 0x402090DC at Data Flow Task, Flat File Destination [4320]: The processing of file "c:\txpfstat.txt" has started.

Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning

Error: 0xC0202009 at Data Flow Task, OLE DB Source [3820]: An OLE DB error has occurred. Error code: 0x80040E00

Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "OLE DB Source" (3820) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.

Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.

Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning

Information: 0x402090DD at Data Flow Task, Flat File Destination [4320]: The processing of file "c:\txpfstat.txt" has ended.

Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning

Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Flat File Destination" (4320)" wrote 0 rows.

Task failed: Data Flow Task

Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SSIS package "Package.dtsx" finished: Failure.

1. The warning is expected, you'll just need to set the "DefaultCodePage" property at your OLEDBSource to the code page you want to use for your string columns, then you can safely ignore it.
2. The fatal error is 0x80040E00, which means "Invalid Accessor", it's raised from the provider rather than from SSIS Source adapter. You may need to double check the SqlCommand you used in the OLEDBSource to see whther that's in good grammar. I tried several cases to switch from OpenRowSet to SqlCommand when connecting to a AS400 DB2 server, I see no problem (I am using the MS OLEDB provider for DB2 though).

Thanks|||1. I don't really understand code pages so I don't know how to set the DefaultCodePage property or what value to set it to. But since the data comes through okay when using OpenRowSet I guess I can just ignore the warning.

2. The SqlCommand is trivial (e.g. "select * from taxdta.txpfstat") so I'm sure the grammer is fine. Certainly the parser within SSIS thinks it fine.

Can anyone else test whether or not SSIS beta works on SQL commands using the IBM Client Access OLEDB data provider? I don't have access to the Microsoft provider to use that instead.

I'm not trying to do anything fancy here just copy entire tables (including creating the table on SQL Server) from the AS400 to SQL server without adversely impacting AS400 producution. Perhaps someone can suggest a better solution besides SSIS for copying from the AS400 to SQL Server.|||I am having the exact same problem trying to transfer data from a PeopleSoft/Oracle database (not on IBM) to a SQL 2005 database. The same transfer works fine in SQL 2000. Any help would be greatly appreciated. The code page that shows on the data source is 1252 and the locale id is English (United States). My SQL statement parses without errors and I can preview the first 200 rows of the query.|||Bill,

Did you get this resolved. Running into the same issue in accessing tables on the iSeries?

thanks,

Guido|||Anyone had any luck with this?

I can get it to work on my dev pc, but not on my server ...

pc = windows xp sp2
server = windows 2003 sp1

both using Client Access v5r3m0...
|||I have the exact same problem... |||We are talking about this in two seperate threads...;) post the link below in case someone here missed the other one which contains more insights on the issue
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=107266

Thanks
Wenyang|||I have almost the same issue. My problem is, I can connect to AS400 without problem using the DTS but (now here comes) when I use this DTS in a Job Schedule the job never ends, I have no errors, no warning, nothing. The first time I stopped the Job 21 hours after it started.
I did the test to make a connection to the sql and send it to a flat file, not a single problem. As soon as I change the connection to the 400 then I have the problem. And as I said before, if I run the DTS manually it runs fine. I'm using September CTP and IBM Client Access V5R1M0 w/ sp SI11806.

If somebody have any idea I appreciate

Thanks,

Arty|||Hi Artiy,

i have had the same problem with the job sceduler but fixed it. The reason is this:
If you are running the dts by yourself then you always have to login to as400. Once you have done your account informations are cached until you log out.
The jobsceduler does not login with the credentials of your ODBC DSN. To fix it you have to create an account on your PC/Server and the as400 which has the same name and the same password. Then use this user for the DTS-Task.

checkity

Accessing AS400 Data

I've been trying to use the integrations services to access AS400 data with almost no success. Any suggestions or help you can give me would be appreciated. Some of the issues I can't make sense of are the following.

1. When I set up an OLEDB data source for the AS400 (using IBM's Client Access provider) I always get a warning message about "Cannot retrieve the column code page information from the OLEDB provider". What do I do about this warning?

2. If the oledb datasource is a table I can sometimes get it to work (though it seems very slow) but if I make the source a sql query it always fails in the first step with an OLEDB error. Any ideas about where to look for the problem?

Below is a sample outlook log from a failure. The only change from a previous example which success was that I changed the Access Mode from OpenRowSet to SQL Command and replace the table name with a sql statement select all the fields in the table.

SSIS package "Package.dtsx" starting.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

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

Warning: 0x80202066 at Data Flow Task, OLE DB Source [3820]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

Information: 0x402090DC at Data Flow Task, Flat File Destination [4320]: The processing of file "c:\txpfstat.txt" has started.

Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning

Error: 0xC0202009 at Data Flow Task, OLE DB Source [3820]: An OLE DB error has occurred. Error code: 0x80040E00

Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "OLE DB Source" (3820) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.

Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.

Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning

Information: 0x402090DD at Data Flow Task, Flat File Destination [4320]: The processing of file "c:\txpfstat.txt" has ended.

Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning

Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Flat File Destination" (4320)" wrote 0 rows.

Task failed: Data Flow Task

Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SSIS package "Package.dtsx" finished: Failure.

1. The warning is expected, you'll just need to set the "DefaultCodePage" property at your OLEDBSource to the code page you want to use for your string columns, then you can safely ignore it.
2. The fatal error is 0x80040E00, which means "Invalid Accessor", it's raised from the provider rather than from SSIS Source adapter. You may need to double check the SqlCommand you used in the OLEDBSource to see whther that's in good grammar. I tried several cases to switch from OpenRowSet to SqlCommand when connecting to a AS400 DB2 server, I see no problem (I am using the MS OLEDB provider for DB2 though).

Thanks|||1. I don't really understand code pages so I don't know how to set the DefaultCodePage property or what value to set it to. But since the data comes through okay when using OpenRowSet I guess I can just ignore the warning.

2. The SqlCommand is trivial (e.g. "select * from taxdta.txpfstat") so I'm sure the grammer is fine. Certainly the parser within SSIS thinks it fine.

Can anyone else test whether or not SSIS beta works on SQL commands using the IBM Client Access OLEDB data provider? I don't have access to the Microsoft provider to use that instead.

I'm not trying to do anything fancy here just copy entire tables (including creating the table on SQL Server) from the AS400 to SQL server without adversely impacting AS400 producution. Perhaps someone can suggest a better solution besides SSIS for copying from the AS400 to SQL Server.|||I am having the exact same problem trying to transfer data from a PeopleSoft/Oracle database (not on IBM) to a SQL 2005 database. The same transfer works fine in SQL 2000. Any help would be greatly appreciated. The code page that shows on the data source is 1252 and the locale id is English (United States). My SQL statement parses without errors and I can preview the first 200 rows of the query.|||Bill,

Did you get this resolved. Running into the same issue in accessing tables on the iSeries?

thanks,

Guido|||Anyone had any luck with this?

I can get it to work on my dev pc, but not on my server ...

pc = windows xp sp2
server = windows 2003 sp1

both using Client Access v5r3m0...
|||I have the exact same problem... |||We are talking about this in two seperate threads...;) post the link below in case someone here missed the other one which contains more insights on the issue
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=107266

Thanks
Wenyang|||I have almost the same issue. My problem is, I can connect to AS400 without problem using the DTS but (now here comes) when I use this DTS in a Job Schedule the job never ends, I have no errors, no warning, nothing. The first time I stopped the Job 21 hours after it started.
I did the test to make a connection to the sql and send it to a flat file, not a single problem. As soon as I change the connection to the 400 then I have the problem. And as I said before, if I run the DTS manually it runs fine. I'm using September CTP and IBM Client Access V5R1M0 w/ sp SI11806.

If somebody have any idea I appreciate

Thanks,

Arty|||Hi Artiy,

i have had the same problem with the job sceduler but fixed it. The reason is this:
If you are running the dts by yourself then you always have to login to as400. Once you have done your account informations are cached until you log out.
The jobsceduler does not login with the credentials of your ODBC DSN. To fix it you have to create an account on your PC/Server and the as400 which has the same name and the same password. Then use this user for the DTS-Task.

checkity

Accessing AS cubes

Hi,

Does anybody knows a good tutorial or some information about accessing analysis services cubes with reporting services?

thanks

I think the following link will give you some information about how to query OLAP Cube from Analysis Service.

http://msdn2.microsoft.com/en-us/library/ms156334(SQL.90).aspx

In addition to that I suggest the web casts posted in the microsoft web site are good resource, particularly Introduction to SQL Server 2005 Reporting Services (Part 5 of 6) (Level 200)

Here is the link:

http://msevents.microsoft.com/cui/webcasteventdetails.aspx?eventid=1032283054&eventcategory=5&culture=en-us&countrycode=us

Sincerely,

Amde

Accessing AS 2005 from ASP.NET application

I have an asp.net application. This application provide consolidated information to the user using Analysis Services 2005.
Within it, one aspx page uses MDX query to retrieve the information from the cube. However, we are unable to access AS 2005 because of authentication issues. What would be the easier to implement and deploy scenario?

How can I access AS 2005 from an ASP.NET application? Is there any feature to use?

Create Views and CTE( common table expressions ) with the results of the MDX queries and render the Views and CTEs in DataGridview controls. That means you are just calling Views query rewrites one persisted and the other in memory or virtual views in Asp.net. This keeps Analysis Service operation out of the Asp.net page life cycle. Hope this helps.

Accessing analysis services from asp.net application

I have an asp.net application. This application provide consolidated information to the user using Analysis Services 2005.
Within it, one aspx page uses MDX query to retrieve the information from the cube. However, we are unable to access AS 2005 because of authentication issues. What would be the easier to implement and deploy scenario?
1) Using kerberos
2) creating a webservice with some Identity to access AS 2005 and using an agent in the application;
3) some other mechanism.

Has AS 2005 come up with some mechanism to allow easy access from web applications (just like sql server authentication in SQL 2005). Is there any feature that we could use? What about anonymous access?

The closest thing we have with AS and sql logins, is http access. Using http access you can set a uid and pwd on the connect string and then the system will use those to authenitcate you against IIS (where the AS server is). This allows your ASP.NET application to use a canned account to access AS. See the connection string parameters allowed on ADOMD.NET (which is what you should be using as a managed provider for your ASP.NET application).

_-_-_ Dave

|||And how do you implement AS role-based security in this scenario?
If you use a canned account to access AS, you cannot match you users with an AS role.
Am I missing something ?|||You didn't say that you wanted to use role-based security, so I gave you a general answer. There are two issues here:

1) getting basic connectivity. If the IIS / ASP.NET machine is in a common domain then you can connect using normal NT authentication (run the virtual directory anonymously and do your own authentication within the application) -- have the anonymouse user for the vd to be a common domain account with the AS server and ensure that it is an Analysis Services sysadmin. If not in a common domain, then use http connectivity and specify an NT UID/PWD which is an AS sysadmin.

2) Once you are connected as an AS sysadmin, then you can use the new EFFECTIVEUSERNAME to set the appropriate username for the connection. Then BINGO there you are.

Hope that helps.

_-_-_ Dave

Accessing Analysis Services 2005 from MS Excel using HTTP from Windows 2000 Server

Hye Friends,
I have installed and configured SQL Server 2005 Analysis Services and MS Office 2000 with the latest Service Packs on Windows 2000 Server. I am able to connect to my Analysis Services from MS Excel using the following URl in Excel ...
http://<ip address>/olap/msmdpump.dll ("olap" being my Virtual Directory)
I was wondering whether I would be able to connect to the same service without using the fully qualified path with only IP-Address... i.e... using only
http://<ip address>
I have been able to implement the above in Windows 2003 Server, but having problems doing the same in Windows 2000 Server. Can anyone help?
Thanks in Advance

How were you able to do so in Windows 2003? I've tried using IIS 6.0 to redirect, but without success.

Accessing 2005 Reports from asp.net 1.1

Our web based Application is based on ASP.NET 1.1 and SQL Server 2005.
Can we use 2005 Reporting Services (ASP.NET 2.0) to create and publish
reports and use them in the 1.1 Application?
(We need to change the Data Source at run time, which is not easy or not
possible in 2000 Reporting Services).
Thanks in advance,
BenjaminIn order to display a report you need just an URL. What seems to be a
problem?
You can view any url in your 1.1 application, even from a different web
site.
Just redirect to it or grab an ouput and display it in your application.
If you have a way of changing datasource in runtime in RS 2005, just create
a 2.0 web page, which does it on load and redirect/transfer from it to the
the report of your choice.
"Benjamin" <benjamin@.servue.com> wrote in message
news:ORZ$mvz9GHA.4196@.TK2MSFTNGP03.phx.gbl...
> Our web based Application is based on ASP.NET 1.1 and SQL Server 2005.
> Can we use 2005 Reporting Services (ASP.NET 2.0) to create and publish
> reports and use them in the 1.1 Application?
> (We need to change the Data Source at run time, which is not easy or not
> possible in 2000 Reporting Services).
> Thanks in advance,
> Benjamin
>

Accessing .Net 2.0 custom assembly in report to be deployed on SSRS 2000 SP2

Hi ,
I am using SQL reporting services 2000 + SP2. In one of my report I am
using custom .Net 1.1 assembly. I have given the reference for the
same in the report.
The report gets deployed without any issues.
Recently we had to upgrade this custom assembly to .Net 2.0. Now when
I try to deploy this report on SSRS 2000 it gives me error "Error
while loading code module:<my custom assembly complete name> " and
"Details: The format of the file <my custom assembly name>is invalid."
I have both .Net 1.1 and .Net 2.0 frameworks on my reporting server.
If I try to give reference to this .Net 2.0 binary again in the report
through IDE (Microsoft Visual Studio .NET 2003 IDE) it gives me error
"<my custom assembly name> does not contain an assembly".
How can I use my .Net 2.0 custom assembly in my SSRS 2000 + SP2
report. I have to use SSRS2000 SP2 as we cannot remove the support of
SSRS2000 SP2 for our reports.
Custom assembly been used is using various .Net 2.0 provided classes
now so it has to be in .Net 2.0.
Can I somehow tell the ASP.Net webapplication through various config
file that while using my custom binary load it in .Net 2.0 Framework?
I tried giving binding redirect but it did not work in the
Reprotserver config file . how can i specify the .Net framework
version in those entries?
Everything works fine in SSRS 2005 as the reporting service is also
in .Net 2.0
Regards,
ManojHi, I have the same issue. Have you got it fixed? How?
Could someone from MSFT give us an answer?
Thanks,
Lianghong
"Manoj" wrote:
> Hi ,
> I am using SQL reporting services 2000 + SP2. In one of my report I am
> using custom .Net 1.1 assembly. I have given the reference for the
> same in the report.
> The report gets deployed without any issues.
> Recently we had to upgrade this custom assembly to .Net 2.0. Now when
> I try to deploy this report on SSRS 2000 it gives me error "Error
> while loading code module:<my custom assembly complete name> " and
> "Details: The format of the file <my custom assembly name>is invalid."
> I have both .Net 1.1 and .Net 2.0 frameworks on my reporting server.
> If I try to give reference to this .Net 2.0 binary again in the report
> through IDE (Microsoft Visual Studio .NET 2003 IDE) it gives me error
> "<my custom assembly name> does not contain an assembly".
> How can I use my .Net 2.0 custom assembly in my SSRS 2000 + SP2
> report. I have to use SSRS2000 SP2 as we cannot remove the support of
> SSRS2000 SP2 for our reports.
> Custom assembly been used is using various .Net 2.0 provided classes
> now so it has to be in .Net 2.0.
> Can I somehow tell the ASP.Net webapplication through various config
> file that while using my custom binary load it in .Net 2.0 Framework?
> I tried giving binding redirect but it did not work in the
> Reprotserver config file . how can i specify the .Net framework
> version in those entries?
>
> Everything works fine in SSRS 2005 as the reporting service is also
> in .Net 2.0
> Regards,
> Manoj
>|||dotNet 2.0 uses a different framework - have you installed the dotnet 2.0
framework on your server?
"Lianghong" <Lianghong@.discussions.microsoft.com> wrote in message
news:7423185E-C8BA-4D1E-BB04-6BF78AD4DCAB@.microsoft.com...
> Hi, I have the same issue. Have you got it fixed? How?
> Could someone from MSFT give us an answer?
> Thanks,
> Lianghong
> "Manoj" wrote:
>> Hi ,
>> I am using SQL reporting services 2000 + SP2. In one of my report I am
>> using custom .Net 1.1 assembly. I have given the reference for the
>> same in the report.
>> The report gets deployed without any issues.
>> Recently we had to upgrade this custom assembly to .Net 2.0. Now when
>> I try to deploy this report on SSRS 2000 it gives me error "Error
>> while loading code module:<my custom assembly complete name> " and
>> "Details: The format of the file <my custom assembly name>is invalid."
>> I have both .Net 1.1 and .Net 2.0 frameworks on my reporting server.
>> If I try to give reference to this .Net 2.0 binary again in the report
>> through IDE (Microsoft Visual Studio .NET 2003 IDE) it gives me error
>> "<my custom assembly name> does not contain an assembly".
>> How can I use my .Net 2.0 custom assembly in my SSRS 2000 + SP2
>> report. I have to use SSRS2000 SP2 as we cannot remove the support of
>> SSRS2000 SP2 for our reports.
>> Custom assembly been used is using various .Net 2.0 provided classes
>> now so it has to be in .Net 2.0.
>> Can I somehow tell the ASP.Net webapplication through various config
>> file that while using my custom binary load it in .Net 2.0 Framework?
>> I tried giving binding redirect but it did not work in the
>> Reprotserver config file . how can i specify the .Net framework
>> version in those entries?
>>
>> Everything works fine in SSRS 2005 as the reporting service is also
>> in .Net 2.0
>> Regards,
>> Manoj
>>|||Yes. The .Net framework 2.0 is installed on the server.
"Bob" wrote:
> dotNet 2.0 uses a different framework - have you installed the dotnet 2.0
> framework on your server?
> "Lianghong" <Lianghong@.discussions.microsoft.com> wrote in message
> news:7423185E-C8BA-4D1E-BB04-6BF78AD4DCAB@.microsoft.com...
> > Hi, I have the same issue. Have you got it fixed? How?
> > Could someone from MSFT give us an answer?
> >
> > Thanks,
> > Lianghong
> >
> > "Manoj" wrote:
> >
> >> Hi ,
> >>
> >> I am using SQL reporting services 2000 + SP2. In one of my report I am
> >> using custom .Net 1.1 assembly. I have given the reference for the
> >> same in the report.
> >>
> >> The report gets deployed without any issues.
> >>
> >> Recently we had to upgrade this custom assembly to .Net 2.0. Now when
> >> I try to deploy this report on SSRS 2000 it gives me error "Error
> >> while loading code module:<my custom assembly complete name> " and
> >> "Details: The format of the file <my custom assembly name>is invalid."
> >>
> >> I have both .Net 1.1 and .Net 2.0 frameworks on my reporting server.
> >>
> >> If I try to give reference to this .Net 2.0 binary again in the report
> >> through IDE (Microsoft Visual Studio .NET 2003 IDE) it gives me error
> >> "<my custom assembly name> does not contain an assembly".
> >>
> >> How can I use my .Net 2.0 custom assembly in my SSRS 2000 + SP2
> >> report. I have to use SSRS2000 SP2 as we cannot remove the support of
> >> SSRS2000 SP2 for our reports.
> >>
> >> Custom assembly been used is using various .Net 2.0 provided classes
> >> now so it has to be in .Net 2.0.
> >> Can I somehow tell the ASP.Net webapplication through various config
> >> file that while using my custom binary load it in .Net 2.0 Framework?
> >> I tried giving binding redirect but it did not work in the
> >> Reprotserver config file . how can i specify the .Net framework
> >> version in those entries?
> >>
> >>
> >> Everything works fine in SSRS 2005 as the reporting service is also
> >> in .Net 2.0
> >>
> >> Regards,
> >> Manoj
> >>
> >>
>
>

ACCESS VIOLATION ERROR

I have been experiencing a fatal error for one of the SQL
Server services on our development server. Upon
investigating on the internet it would appear that we are
not alone in this. The only fix at present appears to be
a server reboot. The error looks something like:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 56 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process.
Until the server was rebooted, some SQL statements (from
any application) worked and others did not. Very
disturbing when using frames within IE, and the queries
running in the upper frame function correctly and the
queries running in the lower frame bomb out (with an error
message akin to 17066 :SQL Server Assertion: File:
< S:\sql\ntdbms\storeng\drs\include\record
.inl>, line=1447
Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <=
MAXDATAROW'.).
Does anybody know the cause of this error message?
ThanksHi Alex.
That seems to be a SQL Server bug. Do make sure that your development server
is fully up to date with service packs as these types of bugs are regularly
picked up & fixed in service packs.
It might help if you posted what SQL is actually being executed when the AV
occurs. If you could send the query & underlying tables someone might be
able to provide you with an equivalent / alternative query which might be an
easy work-around for your immediate problem. There's really not enough
information in your current post to go off though.
Regards,
Greg Linwood
SQL Server MVP
"Alex" <anonymous@.discussions.microsoft.com> wrote in message
news:14e6201c41571$acde15e0$a501280a@.phx
.gbl...
> I have been experiencing a fatal error for one of the SQL
> Server services on our development server. Upon
> investigating on the internet it would appear that we are
> not alone in this. The only fix at present appears to be
> a server reboot. The error looks something like:
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 56 generated fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
> is terminating this process.
> Until the server was rebooted, some SQL statements (from
> any application) worked and others did not. Very
> disturbing when using frames within IE, and the queries
> running in the upper frame function correctly and the
> queries running in the lower frame bomb out (with an error
> message akin to 17066 :SQL Server Assertion: File:
> < S:\sql\ntdbms\storeng\drs\include\record
.inl>, line=1447
> Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <=
> MAXDATAROW'.).
> Does anybody know the cause of this error message?
> Thanks
>

Access to TableAdapter Object in WebPage Class.

Hi, I'm using Reporting Services on my website and for some reports, i get the timeout error after 30 secs.

I declared my object using the Reporting tools and I am using ObjectDataSource.

My report is declared in my aspx page:

<rsweb:reportviewer id="ReportViewer1" runat="server" font-names="Verdana" font-size="8pt" Width="100%" Height="600px">

My ObjectDataSource is declared in my aspx page under my report tag:

<asp:ObjectDataSource ID="ObjectDataSource" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="ReportsTableAdapters.ViewingTotalsTableAdapter">

My TableAdapter is declare in my Reports.xsd file:

<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ViewingTotalsTableAdapter" GeneratorDataComponentClassName="ViewingTotalsTableAdapter" Name="ViewingTotals" UserDataComponentName="ViewingTotalsTableAdapter">

I am trying to access the TableAdapter object from my WebPage Class on the Page_Load event , so I can modify the Command.CommandTimeout. Unfortunately, I cannot find a way to have access to the TableAdater object.

Anyone has any suggestion ?

Thanks,

Richard

Did you ever get a response to this? I am having the same problem.

Access to TableAdapter Object in WebPage Class.

Hi, I'm using Reporting Services on my website and for some reports, i get the timeout error after 30 secs.

I declared my object using the Reporting tools and I am using ObjectDataSource.

My report is declared in my aspx page:

<rsweb:reportviewer id="ReportViewer1" runat="server" font-names="Verdana" font-size="8pt" Width="100%" Height="600px">

My ObjectDataSource is declared in my aspx page under my report tag:

<asp:ObjectDataSource ID="ObjectDataSource" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="ReportsTableAdapters.ViewingTotalsTableAdapter">

My TableAdapter is declare in my Reports.xsd file:

<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ViewingTotalsTableAdapter" GeneratorDataComponentClassName="ViewingTotalsTableAdapter" Name="ViewingTotals" UserDataComponentName="ViewingTotalsTableAdapter">

I am trying to access the TableAdapter object from my WebPage Class on the Page_Load event , so I can modify the Command.CommandTimeout. Unfortunately, I cannot find a way to have access to the TableAdater object.

Anyone has any suggestion ?

Thanks,

Richard

Did you ever get a response to this? I am having the same problem.

Access to integration services

Hi Guys,

I have a quick question, Can i access the SSIS services of a Server from a remote server using Sql Server management studio.

I'm trying to access a third DB server and i can access it using Sql server management studio with sa and password but the integration services aren't there and when i try to explicitly connect to it, it is not connecting

Any ideas?

P.S: Can any of you recommend a very good book as I've done some work with it but it seems i might be the one doing more work with BI from now on as the organisation is not going to appoint anyone else in this position.

Thank you

Gemma

Do you have the SSIS service running on the server? Do you get any error messages?|||

Gemma wrote:

P.S: Can any of you recommend a very good book as I've done some work with it but it seems i might be the one doing more work with BI from now on as the organisation is not going to appoint anyone else in this position.

This is a good book. Especially for doing ETL with SSIS.

http://www.amazon.com/Expert-Server-Integration-Services-Programmer/dp/0470134119/
|||

If you want something that is more of a reference, the Kirk Haselden Microsoft SQL Server 2005 Integration Services is really good. The Wrox Programmer to Programmer SQL Server 2005 Integration Services is also decent. (They cover nearly the same topics, you will only need one or the other)

I'd agree that Expert SSIS is a good book (through about half of it now). The Expert SSIS is more of a walk through while explaining some of the theories and providing tips and best practices. It often tells the reader to refer to the SQL Server 2005 Integration Services book for more detailed information on the various tasks / transforms.

If you are looking for a reference on Datawarehousing / B.I. in relation to SQL 2005 SSIS / Analysis Services / Reporting etc, The Microsoft Data Warehouse Toolkit by Joy Mundy and Warren Thornthwaite is pretty good. If you are just looking for Datawarehousing / B.I. theory then you should probably read The Data Warehouse Toolkit Second Edition by Ralph Kimball.

I also have the Delivering Business Intelligence with Microsoft SQL Server 2005 (Larson) and Practical Business Intelligence with SQL Server 2005 (Hancock) but have not had a chance to read through them as of yet....

|||

Gemma wrote:

Hi Guys,

I have a quick question, Can i access the SSIS services of a Server from a remote server using Sql Server management studio.

I'm trying to access a third DB server and i can access it using Sql server management studio with sa and password but the integration services aren't there and when i try to explicitly connect to it, it is not connecting

Any ideas?

We were having this problem until earlier this week (we are in the beginning phases of using SSIS ourselves). We were able to resolve the access denied issue (if that is what you are having) by following the steps in the following article: http://sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx

|||

Thanks to all of you, who contributed. I have made a note of your suggested books.

Can any of you also tell me a very good t-sql book as I'm really really bad in t-sql?

Thanks again

Gemma

|||

You'll want two: Inside SQL Server 2005: T-SQL Programming and T-SQL Querying. You will need to read the Querying before the programming as the programming book builds off of ideas presented in the first book.

(Although I only bought them a little less than a month ago and haven't read them yet, when I did research those were the two that came with the highest recommandations)

|||

Thank you

Ta

Gemma

access SQL instance issue

I have a MSDE instance running on a server. I am able to start the services
for the
engine. But when I try to access the instance through "SQL Enterprise
Manager" I
get an error message.
"[server name] - SQL Server does not exist or access is denied."
I tried to access the instance through "Windows Authentication" and "SQL
Server Login" and I get the same error message.
I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to start
the SQL services and I can restore a few databases from backup to the
instance.
Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
password
using the SAPWD switch.
Questions:
Is there somthing that I am forgetting to do?
How can I access the instance through SQL Enterprise Manager?
Thanks in advanceGreg,
Instance? Have you tried servername\instancename?
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>I have a MSDE instance running on a server. I am able to start the services
> for the
> engine. But when I try to access the instance through "SQL Enterprise
> Manager" I
> get an error message.
> "[server name] - SQL Server does not exist or access is denied."
> I tried to access the instance through "Windows Authentication" and "SQL
> Server Login" and I get the same error message.
> I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> start
> the SQL services and I can restore a few databases from backup to the
> instance.
> Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> password
> using the SAPWD switch.
>
> Questions:
> Is there somthing that I am forgetting to do?
> How can I access the instance through SQL Enterprise Manager?
> Thanks in advance|||What do you mean servername\instancename?
There is no place to enter that info in SQL Enterprise Manager.
Is there anywhere else I can enter that info?
"Jerry Spivey" wrote:
> Greg,
> Instance? Have you tried servername\instancename?
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >I have a MSDE instance running on a server. I am able to start the services
> > for the
> > engine. But when I try to access the instance through "SQL Enterprise
> > Manager" I
> > get an error message.
> >
> > "[server name] - SQL Server does not exist or access is denied."
> >
> > I tried to access the instance through "Windows Authentication" and "SQL
> > Server Login" and I get the same error message.
> >
> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> > start
> > the SQL services and I can restore a few databases from backup to the
> > instance.
> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> > password
> > using the SAPWD switch.
> >
> >
> > Questions:
> > Is there somthing that I am forgetting to do?
> > How can I access the instance through SQL Enterprise Manager?
> >
> > Thanks in advance
>
>|||Greg,
I don't use MSDE but if EM sees it as another SQL Server and not the default
install then it probably sees it as a named instance. When you're
registering MSDE. For more information on named instances see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> What do you mean servername\instancename?
> There is no place to enter that info in SQL Enterprise Manager.
> Is there anywhere else I can enter that info?
> "Jerry Spivey" wrote:
>> Greg,
>> Instance? Have you tried servername\instancename?
>> HTH
>> Jerry
>> "Greg" <gregkh@.hotmail.com> wrote in message
>> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>> >I have a MSDE instance running on a server. I am able to start the
>> >services
>> > for the
>> > engine. But when I try to access the instance through "SQL Enterprise
>> > Manager" I
>> > get an error message.
>> >
>> > "[server name] - SQL Server does not exist or access is denied."
>> >
>> > I tried to access the instance through "Windows Authentication" and
>> > "SQL
>> > Server Login" and I get the same error message.
>> >
>> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
>> > start
>> > the SQL services and I can restore a few databases from backup to the
>> > instance.
>> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
>> > password
>> > using the SAPWD switch.
>> >
>> >
>> > Questions:
>> > Is there somthing that I am forgetting to do?
>> > How can I access the instance through SQL Enterprise Manager?
>> >
>> > Thanks in advance
>>|||Unfortunatly that did not help. I do not have SQL Server installed. Just an
MSDE instance. I need to access thaat instance from SQL Enterprise Manager. I
only installed EM from the SQL 2000 CD so that I can access the MSDE instance.
How about this, How do I put the MSDE instance in single-user mode?
"Jerry Spivey" wrote:
> Greg,
> I don't use MSDE but if EM sees it as another SQL Server and not the default
> install then it probably sees it as a named instance. When you're
> registering MSDE. For more information on named instances see:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> > What do you mean servername\instancename?
> > There is no place to enter that info in SQL Enterprise Manager.
> >
> > Is there anywhere else I can enter that info?
> >
> > "Jerry Spivey" wrote:
> >
> >> Greg,
> >>
> >> Instance? Have you tried servername\instancename?
> >>
> >> HTH
> >>
> >> Jerry
> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >> >I have a MSDE instance running on a server. I am able to start the
> >> >services
> >> > for the
> >> > engine. But when I try to access the instance through "SQL Enterprise
> >> > Manager" I
> >> > get an error message.
> >> >
> >> > "[server name] - SQL Server does not exist or access is denied."
> >> >
> >> > I tried to access the instance through "Windows Authentication" and
> >> > "SQL
> >> > Server Login" and I get the same error message.
> >> >
> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> >> > start
> >> > the SQL services and I can restore a few databases from backup to the
> >> > instance.
> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> >> > password
> >> > using the SAPWD switch.
> >> >
> >> >
> >> > Questions:
> >> > Is there somthing that I am forgetting to do?
> >> > How can I access the instance through SQL Enterprise Manager?
> >> >
> >> > Thanks in advance
> >>
> >>
> >>
>
>|||Greg,
So MSDE is the only SQL Server installed? Try registering with the machine
IP address. Or if that doesn't work try:
(local)
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> Unfortunatly that did not help. I do not have SQL Server installed. Just
> an
> MSDE instance. I need to access thaat instance from SQL Enterprise
> Manager. I
> only installed EM from the SQL 2000 CD so that I can access the MSDE
> instance.
> How about this, How do I put the MSDE instance in single-user mode?
>
> "Jerry Spivey" wrote:
>> Greg,
>> I don't use MSDE but if EM sees it as another SQL Server and not the
>> default
>> install then it probably sees it as a named instance. When you're
>> registering MSDE. For more information on named instances see:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
>> HTH
>> Jerry
>> "Greg" <gregkh@.hotmail.com> wrote in message
>> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
>> > What do you mean servername\instancename?
>> > There is no place to enter that info in SQL Enterprise Manager.
>> >
>> > Is there anywhere else I can enter that info?
>> >
>> > "Jerry Spivey" wrote:
>> >
>> >> Greg,
>> >>
>> >> Instance? Have you tried servername\instancename?
>> >>
>> >> HTH
>> >>
>> >> Jerry
>> >> "Greg" <gregkh@.hotmail.com> wrote in message
>> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>> >> >I have a MSDE instance running on a server. I am able to start the
>> >> >services
>> >> > for the
>> >> > engine. But when I try to access the instance through "SQL
>> >> > Enterprise
>> >> > Manager" I
>> >> > get an error message.
>> >> >
>> >> > "[server name] - SQL Server does not exist or access is denied."
>> >> >
>> >> > I tried to access the instance through "Windows Authentication" and
>> >> > "SQL
>> >> > Server Login" and I get the same error message.
>> >> >
>> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
>> >> > to
>> >> > start
>> >> > the SQL services and I can restore a few databases from backup to
>> >> > the
>> >> > instance.
>> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
>> >> > sa
>> >> > password
>> >> > using the SAPWD switch.
>> >> >
>> >> >
>> >> > Questions:
>> >> > Is there somthing that I am forgetting to do?
>> >> > How can I access the instance through SQL Enterprise Manager?
>> >> >
>> >> > Thanks in advance
>> >>
>> >>
>> >>
>>|||EM and the MSDE instance are on the same machine. I tried local and IP
address and I still get the same error. Is there anything that I am
forgetting to do?
"Jerry Spivey" wrote:
> Greg,
> So MSDE is the only SQL Server installed? Try registering with the machine
> IP address. Or if that doesn't work try:
> (local)
> HTH
> Jerry
>
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> > Unfortunatly that did not help. I do not have SQL Server installed. Just
> > an
> > MSDE instance. I need to access thaat instance from SQL Enterprise
> > Manager. I
> > only installed EM from the SQL 2000 CD so that I can access the MSDE
> > instance.
> >
> > How about this, How do I put the MSDE instance in single-user mode?
> >
> >
> > "Jerry Spivey" wrote:
> >
> >> Greg,
> >>
> >> I don't use MSDE but if EM sees it as another SQL Server and not the
> >> default
> >> install then it probably sees it as a named instance. When you're
> >> registering MSDE. For more information on named instances see:
> >>
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> >>
> >> HTH
> >>
> >> Jerry
> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> >> > What do you mean servername\instancename?
> >> > There is no place to enter that info in SQL Enterprise Manager.
> >> >
> >> > Is there anywhere else I can enter that info?
> >> >
> >> > "Jerry Spivey" wrote:
> >> >
> >> >> Greg,
> >> >>
> >> >> Instance? Have you tried servername\instancename?
> >> >>
> >> >> HTH
> >> >>
> >> >> Jerry
> >> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >> >> >I have a MSDE instance running on a server. I am able to start the
> >> >> >services
> >> >> > for the
> >> >> > engine. But when I try to access the instance through "SQL
> >> >> > Enterprise
> >> >> > Manager" I
> >> >> > get an error message.
> >> >> >
> >> >> > "[server name] - SQL Server does not exist or access is denied."
> >> >> >
> >> >> > I tried to access the instance through "Windows Authentication" and
> >> >> > "SQL
> >> >> > Server Login" and I get the same error message.
> >> >> >
> >> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
> >> >> > to
> >> >> > start
> >> >> > the SQL services and I can restore a few databases from backup to
> >> >> > the
> >> >> > instance.
> >> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
> >> >> > sa
> >> >> > password
> >> >> > using the SAPWD switch.
> >> >> >
> >> >> >
> >> >> > Questions:
> >> >> > Is there somthing that I am forgetting to do?
> >> >> > How can I access the instance through SQL Enterprise Manager?
> >> >> >
> >> >> > Thanks in advance
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Oh and yes MSDE is the only SQL Server that is installed.
"Greg" wrote:
> EM and the MSDE instance are on the same machine. I tried local and IP
> address and I still get the same error. Is there anything that I am
> forgetting to do?
> "Jerry Spivey" wrote:
> > Greg,
> >
> > So MSDE is the only SQL Server installed? Try registering with the machine
> > IP address. Or if that doesn't work try:
> >
> > (local)
> >
> > HTH
> >
> > Jerry
> >
> >
> > "Greg" <gregkh@.hotmail.com> wrote in message
> > news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> > > Unfortunatly that did not help. I do not have SQL Server installed. Just
> > > an
> > > MSDE instance. I need to access thaat instance from SQL Enterprise
> > > Manager. I
> > > only installed EM from the SQL 2000 CD so that I can access the MSDE
> > > instance.
> > >
> > > How about this, How do I put the MSDE instance in single-user mode?
> > >
> > >
> > > "Jerry Spivey" wrote:
> > >
> > >> Greg,
> > >>
> > >> I don't use MSDE but if EM sees it as another SQL Server and not the
> > >> default
> > >> install then it probably sees it as a named instance. When you're
> > >> registering MSDE. For more information on named instances see:
> > >>
> > >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> > >>
> > >> HTH
> > >>
> > >> Jerry
> > >> "Greg" <gregkh@.hotmail.com> wrote in message
> > >> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> > >> > What do you mean servername\instancename?
> > >> > There is no place to enter that info in SQL Enterprise Manager.
> > >> >
> > >> > Is there anywhere else I can enter that info?
> > >> >
> > >> > "Jerry Spivey" wrote:
> > >> >
> > >> >> Greg,
> > >> >>
> > >> >> Instance? Have you tried servername\instancename?
> > >> >>
> > >> >> HTH
> > >> >>
> > >> >> Jerry
> > >> >> "Greg" <gregkh@.hotmail.com> wrote in message
> > >> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> > >> >> >I have a MSDE instance running on a server. I am able to start the
> > >> >> >services
> > >> >> > for the
> > >> >> > engine. But when I try to access the instance through "SQL
> > >> >> > Enterprise
> > >> >> > Manager" I
> > >> >> > get an error message.
> > >> >> >
> > >> >> > "[server name] - SQL Server does not exist or access is denied."
> > >> >> >
> > >> >> > I tried to access the instance through "Windows Authentication" and
> > >> >> > "SQL
> > >> >> > Server Login" and I get the same error message.
> > >> >> >
> > >> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
> > >> >> > to
> > >> >> > start
> > >> >> > the SQL services and I can restore a few databases from backup to
> > >> >> > the
> > >> >> > instance.
> > >> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
> > >> >> > sa
> > >> >> > password
> > >> >> > using the SAPWD switch.
> > >> >> >
> > >> >> >
> > >> >> > Questions:
> > >> >> > Is there somthing that I am forgetting to do?
> > >> >> > How can I access the instance through SQL Enterprise Manager?
> > >> >> >
> > >> >> > Thanks in advance
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >

Access shared data source inside custom assembly

I have a database connection string hard-coded in a SQL Server 2005 Reporting Services custom assembly. Since the connection string is environment-specific (dev/prod), I would like to read the connections string from a settings file, like is typically done for web.config. Using the shared data source is also a good option.

How do I accomplish this?

I looked into trying to use DataSourceReference(), but that does not seem to be allowed inside of a custom assembly. Thank you.

Only private data sources can be expression-based. You can think of the Report Server as a web application since it runs under IIS. Therefore, you can put your config settings in the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config just like you would do with a regular ASP.NET app. Assuming you've deployed your report to the report catalog, you can read these settings at runtime . Additional considerations:

1. This technique is not supported.

2. Since there is no HttpContext in in the VS.NET Report Designer, you need to check for this condition and default your settings so you report works in design mode. I have a report in this download that demostrates how you can do this.

Access shared data source inside custom assembly

I have a database connection string hard-coded in a SQL Server 2005 Reporting Services custom assembly. Since the connection string is environment-specific (dev/prod), I would like to read the connections string from a settings file, like is typically done for web.config. Using the shared data source is also a good option.

How do I accomplish this?

I looked into trying to use DataSourceReference(), but that does not seem to be allowed inside of a custom assembly. Thank you.

Check Jason's blog here

http://weblogs.asp.net/jgaylord/archive/2005/05/12/406639.aspx

HTH
Regards

|||

Thank you. I read that blog, but it just seems to mention connection strings in general. The issue I am facing is that the Reporting Services assembly does not seem to allow me to access web.config, even though there is a web.config associated with RS. When I try to write "Imports System.Web.Configuration," VS2005 says it is not available and that the WebConfigurationManager is not available.

|||

Ok, simply add the System.Configurations.Dll as a reference in your project.

Let me know if you need further help.

Regards