PaulB-TheOneAndOnly (8/17/2011)

---

amir.mochtar (8/17/2011)

---

sorry before. if i posted in wrong thread.

i just need help, i have problem when binding value in an input variable with pl/sql script in SSIS package.

here...

sorry before. if i posted in wrong thread.

i just need help, i have problem when binding value in an input variable with pl/sql script in SSIS package.

here the illustration...

LutzM (8/16/2011)

---

Please don't hijack a thread.

The issue you describe is not even related to the subject discussed in the original thread.

Ask your question using a new thread in the SSIS...

- deleted -

oohh, so it doesn't need to be split, does it? ... i thought it should split with use such...

the sqlist (8/11/2011)

---

the sqlist (8/11/2011)

---

amir.mochtar (8/10/2011)

---

i created #tmp table when processing large of rows then i made index for some columns, those are often used in inquiry. Did i do...

Hi all,

sorry before if OOT

need help, i have sql statement like this :

select col0, col1, col2

from table1

where substring(col0,1,3) IN (select colref from tableRef where active=1)

if want to convert this...

need help, i have sql statement like this :

select col0, col1, col2

from table1

where substring(col0,1,3) IN (select colref from tableRef where active=1)

if want to convert this statement with SSIS component...

Is there other way other than use merge join ? i don't know what's wrong in my SP or SSIS package. when i use merge join component (with multiple instance,...

i created #tmp table when processing large of rows then i made index for some columns, those are often used in inquiry. Did i do right?

Could it possible to use @table variable or CTE for processing 10 million records up? i'm afraid it will drain the memory.