Hi,
I have the following statement in execute SQL Task....

DECLARE @DATE VARCHAR(30)
SELECT @DATE=VALUE
FROM _PARAMETERS
WHERE NAME='RTB_DATA_DATE'

SELECT 'SELECT ..... from table_Name' <very long statement to be
executed on oracle DB>

I assign this to a user defined variable and then execute it using OLE
DB data source. The problem is that the SELECT 'SELECT.... ' command
is longer than 8000 characters due to which its getting truncated and
not being executed. In SQL Server 2000 I knew how to get around it by
using ActiveX scripts..... what should I do here??

This statement needs to run everyday for the last three days of
data.... and load data from oracle to local SQL Server. I update date
value in _PARAMETERS table and read it into the select statement.

Any help is greatly appreciated.

Zomer.

Can't you do the same "trick" using ActiveX script on the Oracle connection
(via a script component or script task)? Can you create a stored procedure on
the Oracle database and execute that?

Unfortunately i do not have permission to create SP on oracle.... i
have just select permission.... I am trying to work with the script
task but it does not seem to have probable solution.

I guess you already tried rewriting or breaking up the SQL statement? If it
is not confidential, perhaps you could post it so we could have a look at it
and try to reduce it in size. That would solve all your problems.