I would like to execute a ssrs report from within a ssis foreach loop but
there is no task especially for this so I tried to use the web service task
and connect to the ssrs web service but ssis complained about the ssrs wsdl,
does anyone know why and what I can do to fix? Thanks.
--
John Pryor

Hi John,

I don't understand what you are trying to do. Where will the report display?
If you are simply wanting to output a report to a file such as an Excel file,
I suggest that in Reporting Services you create a subscription to a file
share with a one time schedule of a time in the past. Go to SQL Server Agent
and find the name of the job that it has created as a result. In SSIS, use
the Execute SQL Task to run the SQL Server Agent job using the stored
procedure sp_start_job.

If you are trying to view the report while the package is running, then you
have to control things from Reporting Services side. Just create your package
with a DataReader data destination and in Reporting Services use this as a
data source to your report [after uncommenting the SSIS sections in
RSReportDesigner.config].

Charles Kangai, MCT, MCDBA

"john pryor" wrote:

I need to be able to run this parameterized report on the fly, and
specifically from within a SSIS package. I appreciate your solution, but it
doesn't answer the question of why one MS app's WSDL can not be understood by
another MS app.

I'd like to know if MS has an answer or fix, or if anyone else has found a
workaround when using SSRS's WSDL within SSIS. Thanks.

--
John Pryor


"Charles Kangai" wrote:

Just a "bump" for this one - I now have the same requirement. I want to
schedule a few hundred reports, and save them to various folders in a
directory tree with year, month and day information in the path.

I thought I could pull the reports via the web service, and then use script
to determine where to save them.

Any ideas? I too think it odd that the RS WDSL file throws an error in the
WebService Task!

Cheers,


Pete

"john pryor" wrote:

Another bump here.
I would like to use the SSIS webservice functionality to manage user access with the getpolicies and setpolicies methods.
I have read elsewhere that one could customize the wsdl by dropping or commenting out some elements that are beyond SSISs capabilities. I mighttry that. Still, it's awkward that one element of MSSS isn't supported by the other.
Does anyone have a stripped-down version of the SSRS wsdl

From http://www.developmentnow.com/g/103_...g-SSRS-WSDL.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Another bump here.
I would like to use the SSIS webservice functionality to manage user access with the getpolicies and setpolicies methods.
I have read elsewhere that one could customize the wsdl by dropping or commenting out some elements that are beyond SSISs capabilities. I mighttry that. Still, it's awkward that one element of MSSS isn't supported by the other.
Does anyone have a stripped-down version of the SSRS wsdl

From http://www.developmentnow.com/g/103_...g-SSRS-WSDL.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Another bump here.
I would like to use the SSIS webservice functionality to manage user access with the getpolicies and setpolicies methods.
I have read elsewhere that one could customize the wsdl by dropping or commenting out some elements that are beyond SSISs capabilities. I mighttry that. Still, it's awkward that one element of MSSS isn't supported by the other.
Does anyone have a stripped-down version of the SSRS wsdl

From http://www.developmentnow.com/g/103_...g-SSRS-WSDL.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Another bump here.
I would like to use the SSIS webservice functionality to manage user access with the getpolicies and setpolicies methods.
I have read elsewhere that one could customize the wsdl by dropping or commenting out some elements that are beyond SSISs capabilities. I mighttry that. Still, it's awkward that one element of MSSS isn't supported by the other.
Does anyone have a stripped-down version of the SSRS wsdl

From http://www.developmentnow.com/g/103_...g-SSRS-WSDL.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Another bump here.
I would like to use the SSIS webservice functionality to manage user access with the getpolicies and setpolicies methods.
I have read elsewhere that one could customize the wsdl by dropping or commenting out some elements that are beyond SSISs capabilities. I mighttry that. Still, it's awkward that one element of MSSS isn't supported by the other.
Does anyone have a stripped-down version of the SSRS wsdl

From http://www.developmentnow.com/g/103_...g-SSRS-WSDL.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Another bump here.
I would like to use the SSIS webservice functionality to manage user access with the getpolicies and setpolicies methods.
I have read elsewhere that one could customize the wsdl by dropping or commenting out some elements that are beyond SSISs capabilities. I mighttry that. Still, it's awkward that one element of MSSS isn't supported by the other.
Does anyone have a stripped-down version of the SSRS wsdl

From http://www.developmentnow.com/g/103_...g-SSRS-WSDL.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com