Hi Everyone,

I can't believe I'm the only one who wants to bring data over from
Oracle with some element of dynamicness. Nor can I believe that this
problem hasn't been solved already. Here's the problem:

1. Our Data Warehouse is in MS SQL 2000
2. Some source data is in Oracle
3. Some of these tables are large and we want to bring over
incremental updates.
4. We want to grab the last_update date from the target, and use it as
a parameter to filter what comes over.

Something like:

SELECT *
FROM tablename
WHERE
(LAST_UPDATE_DATE > ? )

gives me the error:

General Error -2147217904 (80040E10)


When I click on the "Parameters" button in the "Transform Data Task
Properties" dialogue, I get:

"Package Error
Error Source: Microsoft OLE DB Provider for Oracle
Error Description: Provider cannot derive parameter information
and SetParameterInfo has not been called."



Has anyone solved this problem yet? Can you send me source code? I
would hate to have to use another solution because of a technical
limitation in Microsoft SQL Server.

Thank you,

Scott Shuster
scott_shuster (AT) yahoo (DOT) com

The limitation will not be in SQL Server rather the driver to Oracle. Some
drivers do not support parameters in this way. You can work around this
limitation by doing this

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

--
--

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

"Scott Shuster" <scott_shuster (AT) yahoo (DOT) com> wrote