Oracle to SQL
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
July 19th, 2011 5:26am
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
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2011 5:35am
I want Query thats been passed to Oracle not variables.Navin.D http://dnavin.wordpress.com
July 19th, 2011 5:37am
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
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2011 5:40am
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
July 19th, 2011 5:50am
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
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2011 5:54am