You can use a script simular like this (set Command Type of the dataset to Text):

set nocount on

create table #temp

(

Publication varchar(50)

)

insert into #temp

execute sp_GetPublications

select * from...

I guess you added one of the expressions mentioned before to the group expression of a detail row (you can right-click on the detail row, select Edit Group... and then...

You can only access SSIS variables in the PostExecute method of the script. See for an explanation of the error.

Peter

I would use a global variable for the ToLine and add it to the configuration file. Then assign the variable to the ToLine properties of both mail tasks.

Peter

Looks like a syntax error. Remove the second 'set' keyword.

update cdt_Crawford.cdt_SubscriptionType

set Subscription = ?,

MaxCDs = ?

where SubscriptionType = ?

Peter

Add a group to your report and use the following expression to group on:

=Floor((RowNumber(Nothing) - 1) / 10)

Also set the 'Page break at and' property for the group.

Peter

Your initial expression returned the string "Null" in case the parameter was null. Just replace the "Null" string with "All":

=IIf(IsNothing(Parameters!Rejected.Value), "All", CStr(Parameters!Rejected.Value))

There's no need for VB if i look at...

I don't now what's wrong with the expression, but I get the same error. You can work around it by replacing [font="Times New Roman"]Parameters!Rejected.Value.ToString()[/font] with [font="Times New Roman"]CStr(Parameters!Rejected.Value)[/font]. Looks like...

Look at Site Settings in the Report Manager (http://YourServer/Reports). There's an option Report Execution Timeout which defaults to 1800 seconds.

Hopes this helps.

Peter

I can't tell you what you're doing wrong. Looks okay to me, but maybe the problem is caused by a missing assembly on the server, because everything is working in...

I've always been wondering why this question isn't raised more often. Some of my projects take more than an hour to open. I usually get around this problem by modifying...

A very good question, indeed! My BOL (September 2007) says:

8 The password is incorrect.

9 Password is not valid.

Peter

Confusing stuff! I don't think the isolation level really matters, because a transaction can read it's own data. Maybe you should set the RetainSameConnection on the source connection. I did...

If you're starting the transaction using a SQL task try

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

BEGIN TRANSACTION

Peter

Add a Derived Column Transformation after the Lookup and use the expression "ISNULL([fieldname]) ? 0 : [fieldname]"

Peter