What I want is a way for an Execute SQL Step to get access to a package
global variable so that I can do decisions based on it and I cannot figure
out how. What I have is a global variable called "LogDebug". I need this to
be used in an Execute SQL Task in the following manner:

IF DTSGlobalVariables("ExecutionResult").Value <>0
BEGIN
INSERT INTO DebugLog() VALUES ()
END

How can I accomplish this? I have tried the following:

1)
DECLARE @DebugOn bit
SELECT @DebugOn = ?
IF @DebugOn <>0
BEGIN
INSERT INTO DebugLog() VALUES ()
END

2)
IF ? <>0
BEGIN
INSERT INTO DebugLog() VALUES ()
END

I thought that the ? was the way to indicate parameter usage but I must be
doing something wrong. Anyone have any ideas? I searched and only found
examples of using the "?" character as part of WHERE clauses. Not what I
need it to do.

You can have a look to fo something like this

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

OR

If the ExecuteSQL statement is the last thing in the data flow then why
not check the value of the variable in an Active Script task and then
enable/Disable the ExecuteSQL task. The Active Script task will need to
come before the ExecuteSQL task in the workflow.

Allan

"Mike Sharpe" <MikeSharpe (AT) discussions (DOT) microsoft.com> wrote

Mike,

I think you need to use ActiveX Script task instead of Execute SQL task.
The ActiveX Script task will allow you to use global variables and SQL
statments. It is easy and poweful. Use ADODB.Connection objects.

Hope this info helps.


*** Sent via Developersdex http://www.developersdex.com ***