Unable to Update a ORACLE SQL Query in SSIS DATAFLOW
Hi, I have a data flow where there is a query to pull data from oracle data source. I am having problem while changing the query. Thing is that, when I am changing the query and click on save, the package is getting saved and the changes i have made in query are not getting reflected (i.e., i can only see the past query with out my changes). What are the changes i need to make in properties so that my updated query would work. Thanks in Advance.
July 12th, 2011 9:03am

Hey guys i have found it my self. Just got the properties of the task and find the expression. click on expand and edit the query as required. Now do the same changes in the query field of the task. Now click save. Now the changes are saved and we can run the task fine.
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2011 9:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics