开发者

SSIS 2005 Saving Problem - SQL Task Editor

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜