I'm using SEM 8.0

I've installed XPSMTP from http://www.sqldev.net/xp/xpsmtp.htm and it is
working fine.

What I'd like to do now is to get the @subject parameter from a global
variable.
So I'd like to exec it like this:

exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'someuser (AT) domain (DOT) com',
@subject = ?,
@......,
@.....

When I click on the parameters button to set the parameter, it get this
error:
'Syntax error or access violation'.

Is it not possible to pass parameters dynamically to this extended stored
procedure?

Thanks,
Al

I am going to presume that you want to do this in an ExecuteSQL task.

The developement environment is not that sturdy sometimes and this may be
one of those times so personally I would build my SQLStatement up in an
Actve Script task and plug it in that way.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Al Cadalzo" <cadalzo (AT) hotmail (DOT) com> wrote

Allan,

Yes, your presumption is correct. I want to do it in an ExecuteSQL task.

I like your suggestion of building it in an ActiveScript task. That's what
I'm going to do.
Wish me luck.

Thanks,
Al

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

good luck

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Al Cadalzo" <cadalzo (AT) hotmail (DOT) com> wrote

Allan,

Works fine. I needed to get to the CustomTask object (instead of the task
object) in order to set the SQLStatement. I did it by going through the
DTSGlobalVariables.Parent package and then it's Tasks, and finally
Task.CustomTask.

Thanks,
Al


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

For reference, here is an example of using script to manipulate the SQL
statement.

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)


"Al Cadalzo" <cadalzo (AT) hotmail (DOT) com> wrote

Darren,

Thanks so much for that. Your sqldts.com site is an invaluable resource.

Thanks,
Al


"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote