I need to use the result of MAX(date_XX)in connection 2 in
the "where" clause of connection 1.

From what I've read I can either us a global variable or a
look-up.

Documentation is very unclear (or just difficult for me to
understand). Can any of you kind people suggest which one
is best and provide a sample instructions.

Thank you in advance!

Thanks for the information.

I have set up the Exec SQL task and created the Global
variable with the output result.

When I go to set up the input parameter to make the
variable available, I receive an error message when I
click on the parameter button on the source tab of the
data pump.

That connection i am using a Sybase ODBC connection. The
mssage I am getting is :

"Microsoft OLEDB provider for ODBC driver."

"Provider can not derive parameter information and
serparameterinfo has not been called."

Any help would be appreciated.

Ahhhhhhhhh

Perhaps your driver does not allow parameters

What is the statement you are using ?

You still have a few choices.

1. To feed a GV

DataPump task - Source = Your Statement - Destination = do not choose
anything but add an AX Transform. In your script it will look something
like

DTSGlobalVariables("GV").Value = DTSSource("MyField")


2. To use the GV

You can use an Active Script task to create the statement for the ExecuteSQL
Statement rather like

Global Variables and SQL statements in DTS
http://www.sqldts.com/default.aspx?6,102,205,7,1

--

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



"Gary" <gary.conte (AT) am (DOT) sony.com> wrote