Dataset has a single word for its query string

Question

Dataset has a single word for its query string

Bullfrog

SSC Eights!

Points: 895
More actions
July 29, 2008 at 7:34 am

#194964

I'm trying to troubleshoot an existing rdl file someone else has created.
For its dataset (in BI), it show the Command Type as: Text, and the Query
String as: 'Conveyor'. A few other rdl files show: 'Ramp', or 'Schedule' in
their Query String box.
Does anyone know how to trace this back to the SQL tables?
BTW - It does work on the production server, but when I bring the rdl into
BI, it freaks on this entry.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

toolman-352714 SSCrazy Points: 2495 More actions · Answer 1

My guess is those single word queries are actually stored proc names. In order to track back to the actual tables, you'll need to look at these procs and see which tables are referenced in the FROM clause.

My second guess as to why the rdl "freaks" in BIDS is simply loading the rdl to a project doesn't load the data source(s). Once you've cracked the stored procs, you'll know what tables to select as datasources. What's the exact message you're getting when it "freaks?"

Hope this sheds some light

Bullfrog (7/29/2008)
I'm trying to troubleshoot an existing rdl file someone else has created.
For its dataset (in BI), it show the Command Type as: Text, and the Query
String as: 'Conveyor'. A few other rdl files show: 'Ramp', or 'Schedule' in
their Query String box.
Does anyone know how to trace this back to the SQL tables?
BTW - It does work on the production server, but when I bring the rdl into
BI, it freaks on this entry.

[font="Comic Sans MS"]toolman[/font]
[font="Arial Narrow"]Numbers 6:24-26[/font]

Bullfrog SSC Eights! Points: 895 More actions · Answer 2

It does not appear to be a stored procedure, as the query type is set to 'Text' versus 'storedprocedure', and I've looked in the db.

The error it gives when I goto the preivew pane in BI is: "Query execution failed for data set 'MyDataSet'. Incorrect syntac near 'Conveyor'. The dataset shows up on the left of BI with various columns.

Sandip Shinde SSCrazy Points: 2068 More actions · Answer 3

You are working on file some one created right.

First thing if Command Type = Test then there should be some SQL Query in CommandText.

If command Type = SP then there should be sp which is availalbe in your database.

If this is not the case then that someone really did some monkey business with the rdl files.

Is that someone is still in your contact then catch him up.

Wish you all the best.

Sandip