SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report off of SSIS package writing to datareader dest.


Report off of SSIS package writing to datareader dest.

Author
Message
jeffsmith.or
jeffsmith.or
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 43
Hi All,

In SQL Server 2005, I'm struggling with defining a connection between Reporting Services and an Integration Services package that writes to a Data Reader destination. Any help greatly appreciated. This is a simple "hello world" type app just to shake out the basic connectivity issues. In the dvel environment I'm working in, Reporting Services and Integrations Services are running on the same server.

I've read various threads and also read the Books Online "Defining Report Datasets for Package Data from SQL Server Integration Services" article, but obviously am still in need of a few more details. The unattended execution account has been configured and the SSIS data processing extension. In RSReportDesginer.config, I un-commented out the two lines referring to SSIS as a source type. I moved the package I developed (Baseball_Test_Package.dtsx) to the root level of my local c drive, and opened up Reporting Services. I clicked on New Report and in the Wizard, at the Select the Data Source screen, specified settings with New DataSource Name: Datasource1, Type:SSIS and Connection String: -f c:\Baseball_Test_Package.dtsx. Got the below message when I clicked Next:

A connection cannot be made to the database.
Set and test the connection string.
The package failed to validate.

Is that error referring to the specification in the Connection String box on this dialogue, or does the problem lay elsewhere? Thank you in advance for any suggestions.
jeffsmith.or
jeffsmith.or
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 43
From a post in another forum, I was informed that the SSIS extension for Reporting Services in SQL SERVER 2005 is not reliable, should not be used in production, and probably should not have been included in the 2005 release. So, therefore, at this point, I'm looking at other means to accomplish my goals. Thought I'd share just in case anyone was having the same troubles...Smile
patr
patr
SSC-Enthusiastic
SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)

Group: General Forum Members
Points: 136 Visits: 149
hi
even I am also facing the same problem and am getting the error like SSIS EXECTION SYNTAX NOT VALID ....

I have uncommented the
patr
patr
SSC-Enthusiastic
SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)

Group: General Forum Members
Points: 136 Visits: 149
hi
even I am also facing the same problem and am getting the error like SSIS EXECTION SYNTAX NOT VALID ....

I have uncommented SSIS DATASOURCE in config files and given the path as /file "c:/package.dtsx"
In report dataset I have given the query as DataReaderDest in text type...

please help me out ...
thanks in advance

If u come across the same issues please let me know it.
w2bsqldba
w2bsqldba
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 606
you need to give in double qutes(") the pacakge location

for example:

-f "C:\users\demo\SSISTest\Package.dtsx"


Let me know if it does not work


Thanks,
Brahma
shrsan
shrsan
SSC Journeyman
SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)

Group: General Forum Members
Points: 80 Visits: 117
Thank you soo much Brahma.... i have been trying it from 2days i just have to add(""):-)

finally...Once again thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search