Hi,
I am using execute SQL task to build dynamic query and then save it in
a variable. Then I use this variable in data flow task <SQL Command
from a variable> to obtain data from Oracle DB. The problem is that I
am unable to save more than 8000 character query to the variable. I
have tried spliting up the query.... exec(var1+var2) but nothing works.


Any help or ideas are apprecaited.

Thanks.