Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 6 of 6
Search took 0.01 seconds.
Search: Posts Made By: palli
Forum: SQL Server DTS May 29th, 2007, 04:56 AM
Replies: 0
Views: 1,573
Posted By palli
Run a Reporting Services report from within SSIS

Hi !

How does one run a reporting services report from within SSIS?

The report will either email the resulting reporting output, or write it to a file.

What I've found so far is that there...
Forum: Reporting Services May 29th, 2007, 01:42 AM
Replies: 2
Views: 1,304
Posted By palli
Well, I can at least give you an idea :-) I...

Well, I can at least give you an idea :-)

I haven't been able to test the code but the idea should work. First, you find a list of all the different (param_name, param_value) pairs for each...
Forum: Reporting Services May 29th, 2007, 01:25 AM
Replies: 1
Views: 912
Posted By palli
I think you can't do what you are trying to do...

I think you can't do what you are trying to do with a stored procedure.

SPs return rowset as a result set, which actually is not easy to use in a later stages of the procedure. It can be done,...
Forum: Reporting Services May 28th, 2007, 02:51 PM
Replies: 1
Views: 689
Posted By palli
Try to prefix the function call with the schema...

Try to prefix the function call with the schema name, probably "dbo." then calling "dbo.fname(x,y)"

Palli
Forum: BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 May 28th, 2007, 12:34 PM
Replies: 0
Views: 1,229
Posted By palli
Updating data from a report ?

Hi !

Using SQL Server 2005, SSIS, SSRS ... all on Windows 2003 Server running SQL2005.

I have a business application that writes transaction-like lines to a table, which are then meant to be...
Forum: Reporting Services May 28th, 2007, 12:32 PM
Replies: 0
Views: 845
Posted By palli
Updating data from a report ?

Hi !

Using SQL Server 2005, SSIS, SSRS ... all on Windows 2003 Server running SQL2005.

I have a business application that writes transaction-like lines to a table, which are then meant to be...
Showing results 1 to 6 of 6

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.