I am using oracle as data source and SQL as data destination. In dataflow i used oledb source and oledb destination. oledb source take variables from script task dynamically. Now i want to know what query is exactly passed to oracle engine. How can i fetch what information is passed to my soure database. Regards, NavinNavin.D http://dnavin.wordpress.com

use breakpoints in the script task and see the value of variable http://msdn.microsoft.com/en-us/library/ms141754.aspx http://www.mssqltips.com/tip.asp?tip=1110 Cheers, Shailesh

I want Query thats been passed to Oracle not variables.Navin.D http://dnavin.wordpress.com

You mention in post oledb source take variables from script task dynamically so you can see the query if you are making dynamic query in script task and storing in a variable by seeing variable value.Cheers, Shailesh

But i want to know what query is been passed to Oracle, i require that. Not variable values. They are going fine. And i dont get error on oledbsource as well. I want to run it against oracle and change it as required.Navin.D http://dnavin.wordpress.com

But i want to know what query is been passed to Oracle, i require that. Not variable values. They are going fine. And i dont get error on oledbsource as well. I want to run it against oracle and change it as required. Navin.D http://dnavin.wordpress.com sorry i misunderstood your question no idea how you can see the query which is going to oracle engine.Cheers, Shailesh