1

I have to get data from database1 something like 

select *
from tab1
where dtCol > <*dtVariable*>

The value of dtVariable comes from database2 from 

select *
processdt
where proc_name = 'PROCESS1'

Can you please let me how to do this?

I am using SSIS 2008
Oracle db - 12c
Oracle Drivers - Attunity 1.2

No DBLInks ( basically, we need to avoid using db links)

Ras Knorr
  • 43
  • 6
  • is there a dblink from database1 to database2? (`select * from all_DB_LINKS`) or a (1/2) linked server to the oracle databases in SSIS? If DB link.... `SELECT * from tab1 where dtcol > (Select DTvariable from processdt@database2 where proc_name = 'PROCESS1')` assuming dtvariable is column name and proc_name of process will result in a single value. – xQbert May 09 '17 at 19:50
  • No Dblinks.. All this is to avoid dblinks and Materialized views.. – Ras Knorr May 09 '17 at 20:09

1 Answers1

0

You would simply need to pull the input value from Db2 to a variable in SSIS as step 1. Step 2, you would create an expression that forms that SELECT sql call encompassing that variable. MSDN has an article how to use Execute SQL Task.

Arthur
  • 1,441
  • 1
  • 13
  • 17
  • Sorry to ask.. Being a novice to SSIS, Can you please give some steps how to do this? – Ras Knorr May 10 '17 at 14:43
  • Hi @RasKnorr added the link to the official documentation. You can find more in various blog posts on this topic. – Arthur May 10 '17 at 17:09