Hi everyone,

I have what seems to be a common problem. I'm using SSIS to pull data
from Oracle. I have an Execute SQL Task that sets a variable for the
LastUpdateDate. I want to use this value in the Data Flow task that
will pull the Oracle data. Everything I read points me towards using
the "SQL Command from variable" access mode, but I can't figure out how
to get the LastUpdateDate into the variable that has the SQL command.

Anyone else run into this problem?

Thanks,

Mark

This may be better asked in the 2005 forums but here is what you will
need to do

In Control Flow

ExecuteSQL task reads your LastUpdateDate into a Variable. (is this a
rowset or a single value)


In Data Flow

Your source statement for the pipeline will be a SQL Command ("SQL
Command From Variable" would be if you had the whole statement in a
variable)

Something like

SELECT <column list> FROM <table> WHERE <column> = ?

You can then map the variable to the ? By clicking on the parameters
button.

If your provider does not support ? As a parameter then you could use
the "SQL Command From Variable" and in the Control Flow build the
statement.

Allan



"mark.dalton (AT) ceridian (DOT) com" <markd (AT) magenic (DOT) com> wrote

Thanks for your reply Allan. I'm pulling data from Oracle and neither
the Microsoft nor the Oracle OLE DB provider seems to support ? as a
parameter, so I'm forced to build the command from a variable. This is
where I'm running into trouble - building the SQL command using my
LastUpdateDate variable.

By the way - what are the 2005 forums - I couldn't find them using
Googl Groups.

Thanks again,

Mark

So you could build your variable to be evaluated as an expression.

The MSDN forums are here

http://forums.microsoft.com/msdn/Sho...spx?ForumID=80


Allan

"mark.dalton (AT) ceridian (DOT) com" <markd (AT) magenic (DOT) com> wrote