I have a relatively big SSIS package which I'm trying to edit. I basically need to update a query on an Execute SQL Task. Problem is the solution is not saving the query when I do the change. I open the SQL Task, change the query and close the task. I verify the change before saving and it's there but as soon as I click on the save button the change on the query disappears.
I verified for opened instances of the package but there are no other sessions on the machine. It does seems to be saving correctly on other packages in开发者_开发问答cluded in the solution, but for some reason is not saving on my main package.
Make sure you have a backup copy of your package before you try this:
- close the package (but keep the solution open)
- right click the package and view code
- search for your query and replace the query text with your new query text
- save it
- now double click the package to open it up like you normally do and view the query
精彩评论