Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

.Net driver used as ADO.Net source in SSIS works - does not work in SSRS Expand / Collapse
Author
Message
Posted Tuesday, June 10, 2014 1:23 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:22 AM
Points: 656, Visits: 939
For Reporting Services 2012 on Windows Server 2012 --

I am trying to add new new connection type to SSDT for SSRS. I have a .Net driver that I can use as a ADO.Net source in SSIS and want to use the same driver in SSRS. I can add it as a Data Connection under server explorer but cannot reference it on a report. thoughts?


BT
Post #1579386
Posted Tuesday, June 10, 2014 3:07 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 13,252, Visits: 10,135
Server Explorer doesn't have anything to do with SSRS.
You need to create a connection in the data sources of the report which is located in the Report Data pane (or under Shared Data Sources in the SSRS solution).




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1579423
Posted Wednesday, June 11, 2014 9:11 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:22 AM
Points: 656, Visits: 939
Using SQL Server 2012, SSDT: Maybe a picture would help… (see my attached PIC)

After right-clicking on Data Sources and select Add New Data Source this is the prompt. How do we add to the list of data source types?


BT

  Post Attachments 
Datasource.png (4 views, 51.88 KB)
Post #1579675
Posted Wednesday, June 11, 2014 12:04 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 13,252, Visits: 10,135
It might be possible to add a custom data source extension, but I have never done it before.

Take a look at this page:
Data Sources Supported by Reporting Services (SSRS)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1579765
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse