I am have scenario where there is a need to pull & compare data from two different data sources. One is a oracle & other is MS Sql
I need to match both ID column from both data sources. I am passing MS sql data as a parameter to the oracle dataset.
I am using OLE DB for both oracle & sql data sources. I have checked around the native driver options as well.
I am able to preview data in both data sets individually
However when i validate oracle query, its not passing successfully as its not able to pass sql parameter.
Request to help resolve this.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?