Yes, blocking was the issue. Thanks.

This turned out to be an issue with the way I was cascading my parameters. I had the parameters in the wrong 'physical' order.

CSDunn

Thanks for the feeback. I suspected that having spaces in the folder names was an issue. However, I changed those destination folder names not to have spaces, and I still...

Burninator (3/20/2012)

---

You can add as many static rows in the Tablix as you would static columns in a "regular" table set up. Pretty handy...

As a suggestion, just play around...

Burninator (3/20/2012)

---

Ahhh. Misunderstood your requirement. You should be able to accomplish your goal with a Table control. Try this:

-- insert table, select dataset

-- in Row Group menu,...

Burninator (3/19/2012)

---

Yes it can. Insert a...

Thanks. Who was the training company?

This turned out to be a problem with a rule on the Exchange server. The proc works as intended.

Thank you for your help!

CSDunn

Below is the actual stored procedure that I'm using:

CREATE PROCEDURE [dbo].[spETL_CreatePositivePay_EventNoticeNoPayEntries]

(

@PackageName nvarchar(100),

@MachineName nvarchar(100)

)

AS

DECLARE

@EventNoticeIDLocal Int,

@Profile_NameLocal varchar(10),

@SubjectTextLocal nvarchar(255),

@BodyLocal nvarchar(max),

@Body_FormatLocal varchar(20),

@ToLocal varchar(max),

@PackageNameLocal nvarchar(100),

@MachineNameLocal nvarchar(100),

@ProcessDateLocal datetime

SELECT@PackageNameLocal = @PackageName,

@MachineNameLocal = @MachineName,

@ProcessDateLocal = GETDATE()

BEGIN TRY

SET...

The messages are being sent through the 2007 version of Microsoft Exchange Server.

The same thing happens for the Subject. If the string is beyond a certain small number of characters in length, the email is not sent.

Thank you for your help!

CSDunn

I was able to fix this problem yesterday. Thanks.

I've already fixed this problem. Thanks.

I should add that the ServerIdentity table contains a record for a server named CAUAT, and another for CAUAT1.

I think what is happening is that, in the CASE statement, CAUAT...