开发者

SSIS 2005 Saving Problem - SQL Task Editor

开发者 https://www.devze.com 2022-12-09 22:46 出处:网络
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

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
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号