Hi Phil,

am using .csv flat file destiantion and can able to export all the datas from db to .csv file, even some laks of datas i can export. There is...

Yes. This topic is different from previous post. Upto execute sql task, I've done, variable got filled, now need to transfer the query in variable to oracle then to .txt

Sql...

Thanks a lot, by two string variables varInsert+varSelect, I've done the inserting.

Thanks once again:-)

The SELECT query is not static. It varies depends upon unique_id of sql table, that's why I tried to get the query inside the sql_column, and insert into #temp table,...

Please, could you guys explain with a sample case, since i need it in urgent. Is it possible to insert into table with select query from variable?

My requirement is like that, if that is effectively useless for you means not for all. Possible help me, else leave it.

Anyone else give me an idea to get datas...

Actually, i've manually created one .csv file in C:\Temp\ and assigned the column names which i need and from OLEDB source getting the data from Table and passing it to...