David,

You can't. However, as you pointed out the Operator can be configured with an SMTP address.

If the goal is to send to a group of users then a distribution...

Check the properties on the SQL Server Agent, under Alert System. I believe you'll need to restart the agent if you make a change there.

How about taking an approach of removing characters that aren't digits or a decimal, then converting and summing?

[font="Courier New"]SELECT SUM(CAST(dbo.ufn_digits(column1) AS MONEY)) FROM Table1[/font]

CREATE FUNCTION dbo.ufn_digits(@x AS VARCHAR(MAX))

RETURNS VARCHAR(MAX)

AS

BEGIN

WHILE PATINDEX('%[^0-9.]%',...

Have you tried casting the data type as MONEY and then SUM?

[font="Courier New"]SELECT SUM(CAST(column1 AS MONEY)) FROM Table1[/font]

Based on your description is this what the package currently looks like?

Control Flow

[Data Flow Task] ---> [Send Mail Task]

Data Flow

[OLE DB Source] ---> [Excel Destination]

I haven't tested this but try...

Niraj,

A similar issue with using "replyto" showed up in Database Mail if you had the .NET Framework 2.0 SP1 installed.

Take at look at this blog for some details and links...

Can you post an example of your varbinary columns contents and what you want to see in the text file?

For example, if the VARBINARY column contains 0x616263 do you want...

Going on one of your other posts, are you still using a version of the SQL Native Client? Try using the one labeled "SQL Server" (SQLSRV32.DLL), not "SQL Native Client"...

Not sure then.

How does your setup differ from following example?

Server1 running Windows 2003 has a local user account named User1 which is a member of the local administrators group. ...

When you configured the Perfmon Counter there's a section named "Run As", use your credentials for that.

One of the workarounds is to read an entire line is as a single row, then use the Script Component and write your own logic to break it apart and...

If you're using the SQL Native Client try using the older SQL client in your DSN.

Also, make sure the counter is set to run with a Windows username/password that has...

Read this article; Parsing CSV Values Into Multiple Rows, by Rob Volk

The only difference is that your seperator appears to be an underscore instead of a comma.

Give it...

I can see where a single statement would seem cleaner, how about something like this?

SELECT DocumentName as "Routing/DocumentName",

( SELECT Regum FROM Inspections WHERE Processed=0 FOR XML PATH('InspRqst'),TYPE )

FROM Routing...

Combining those two XML fragments could be done like this.

DECLARE @xmlresult1 XML

DECLARE @xmlresult2 XML

SET @xmlresult1 = (SELECT DocumentName FROM Routing FOR XML AUTO, ELEMENTS)

SET @xmlresult2 = (SELECT Regum FROM Inspections...