|
|
You're in the
sql server reporting services
group:Problem in RTM Version
sql server reporting services:
cannot add an SSIS datareader as a datasource type. In fact, SSIS does not appear in the drop-down list. I uncommented the SSIS data reader extension in the rsreportserver.config file, but it still will not allow me to select SSIS as a a datasrouce type. Can anyone help?
Tom, I am having a problem with the RTM where setup is installing SSRS but
it is not installing the databases that go with SSRS. SQL runs, but I can't connect to SSRS even though it is installed. Out of curiosity, have you checked to see if the two SSRS db's are actually installed? ReportingServer and ReportServerTempDB Mike [quoted text, click to view] "Tom" <Tom@discussions.microsoft.com> wrote in message news:3F380C24-8C79-4C17-A0F1-141D8364D6E6@microsoft.com... > After installing the RTM version of SQL 2005, I have noticed a problem. I > cannot add an SSIS datareader as a datasource type. In fact, SSIS does not > appear in the drop-down list. I uncommented the SSIS data reader extension > in > the rsreportserver.config file, but it still will not allow me to select > SSIS > as a a datasrouce type. Can anyone help? >
Two questions:
* did you actually install the SSIS components? * did you also modify the RSReportDesigner.config file to enable the SSIS data extension in report designer? -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Tom" <Tom@discussions.microsoft.com> wrote in message news:3F380C24-8C79-4C17-A0F1-141D8364D6E6@microsoft.com... > After installing the RTM version of SQL 2005, I have noticed a problem. I > cannot add an SSIS datareader as a datasource type. In fact, SSIS does not > appear in the drop-down list. I uncommented the SSIS data reader extension > in > the rsreportserver.config file, but it still will not allow me to select > SSIS > as a a datasrouce type. Can anyone help? >
SSIS Components are installed. I can create packages in BIDS and the service
is started. The rsreportserver.config, not the RSReportDesigner.config, file has been modified by uncommenting the entry in the data extension section: <Extension Name="SSIS" Type="Microsoft.SqlServer.Dts.DtsClient.DtsConnection,Microsoft.SqlServer.Dts.DtsClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/> [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Two questions: > * did you actually install the SSIS components? > * did you also modify the RSReportDesigner.config file to enable the SSIS > data extension in report designer? > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "Tom" <Tom@discussions.microsoft.com> wrote in message > news:3F380C24-8C79-4C17-A0F1-141D8364D6E6@microsoft.com... > > After installing the RTM version of SQL 2005, I have noticed a problem. I > > cannot add an SSIS datareader as a datasource type. In fact, SSIS does not > > appear in the drop-down list. I uncommented the SSIS data reader extension > > in > > the rsreportserver.config file, but it still will not allow me to select > > SSIS > > as a a datasrouce type. Can anyone help? > > > >
You may have already checked this and sorry if I'm stating the obvious,
but you need to configure the RS server where you create the DBs etc. Under SQL Server configuration Tools is a Report Server Configuration tool that installs the DB, sets encryption etc. A lot nicer than before. Ryan
Yes, I did that.
[quoted text, click to view] "Ryan" wrote:
> You may have already checked this and sorry if I'm stating the obvious, > but you need to configure the RS server where you create the DBs etc. > Under SQL Server configuration Tools is a Report Server Configuration > tool that installs the DB, sets encryption etc. > > A lot nicer than before. > > Ryan >
Yep. That fixed it. Here's the problem: the link at
http://msdn2.microsoft.com/en-us/library/ms159215 states that you only modify the rsreportserver.config. This should probably be fixed. Thanks! [quoted text, click to view] "Jasper Smith" wrote:
> You need to uncomment it in the RSReportDesigner.config (need to uncomment 2 > lines) as well to be able to design reports using an SSIS datasource. > > -- > HTH > > Jasper Smith (SQL Server MVP) > http://www.sqldbatips.com > I support PASS - the definitive, global > community for SQL Server professionals - > http://www.sqlpass.org > > "Tom" <Tom@discussions.microsoft.com> wrote in message > news:09178B37-C059-4C72-9ED8-9E7B4A3CB7A7@microsoft.com... > > SSIS Components are installed. I can create packages in BIDS and the > > service > > is started. > > > > The rsreportserver.config, not the RSReportDesigner.config, file has been > > modified by uncommenting the entry in the data extension section: > > <Extension Name="SSIS" > > Type="Microsoft.SqlServer.Dts.DtsClient.DtsConnection,Microsoft.SqlServer.Dts.DtsClient, > > Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/> > > > > > > "Robert Bruckner [MSFT]" wrote: > > > >> Two questions: > >> * did you actually install the SSIS components? > >> * did you also modify the RSReportDesigner.config file to enable the SSIS > >> data extension in report designer? > >> > >> -- Robert > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> > >> > >> "Tom" <Tom@discussions.microsoft.com> wrote in message > >> news:3F380C24-8C79-4C17-A0F1-141D8364D6E6@microsoft.com... > >> > After installing the RTM version of SQL 2005, I have noticed a problem. > >> > I > >> > cannot add an SSIS datareader as a datasource type. In fact, SSIS does > >> > not > >> > appear in the drop-down list. I uncommented the SSIS data reader > >> > extension > >> > in > >> > the rsreportserver.config file, but it still will not allow me to > >> > select > >> > SSIS > >> > as a a datasrouce type. Can anyone help? > >> > > >> > >> > >> > >
You need to uncomment it in the RSReportDesigner.config (need to uncomment 2
lines) as well to be able to design reports using an SSIS datasource. -- HTH Jasper Smith (SQL Server MVP) http://www.sqldbatips.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org [quoted text, click to view] "Tom" <Tom@discussions.microsoft.com> wrote in message news:09178B37-C059-4C72-9ED8-9E7B4A3CB7A7@microsoft.com... > SSIS Components are installed. I can create packages in BIDS and the > service > is started. > > The rsreportserver.config, not the RSReportDesigner.config, file has been > modified by uncommenting the entry in the data extension section: > <Extension Name="SSIS" > Type="Microsoft.SqlServer.Dts.DtsClient.DtsConnection,Microsoft.SqlServer.Dts.DtsClient, > Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/> > > > "Robert Bruckner [MSFT]" wrote: > >> Two questions: >> * did you actually install the SSIS components? >> * did you also modify the RSReportDesigner.config file to enable the SSIS >> data extension in report designer? >> >> -- Robert >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> "Tom" <Tom@discussions.microsoft.com> wrote in message >> news:3F380C24-8C79-4C17-A0F1-141D8364D6E6@microsoft.com... >> > After installing the RTM version of SQL 2005, I have noticed a problem. >> > I >> > cannot add an SSIS datareader as a datasource type. In fact, SSIS does >> > not >> > appear in the drop-down list. I uncommented the SSIS data reader >> > extension >> > in >> > the rsreportserver.config file, but it still will not allow me to >> > select >> > SSIS >> > as a a datasrouce type. Can anyone help? >> > >> >> >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |