通过

Why Debug command is disabled for my SSIS package?

  • 项目

Debugging support for SSIS packages is probably one of the best features of the SSIS 2005 designer, but sometimes you may find that "Start Debugging" (F5) and "Start without Debugging" (Ctrl-F5) commands are grayed out. Why?

The reason might be obvious to developers who worked with Visual Studio, but hard to find to people coming with DTS experience. In Visual Studio the debugging facilities are provided by the project, so you can't debug if you opened a .DTSX file standalone, without a project.

If you have a project (.DTPROJ file) that includes this package, just open this project and you'll be able to debug the package. If you just got a standalone DTSX file from somewhere and want to debug, you need to create a project:

  1. create a new SSIS project (File > New > Project > Business Intelligence Projects > Integration Services)
  2. (optional) you may delete the default package
  3. right click the project node, select Add > Existing Item.. menu, add the package to your project
  4. debug

Note that adding the package creates a copy of the package in the project folder, so all edits affect this copy instead of the original.

Other trivia: debugging artifacts, like breakpoints and visualizers are part of the solution (to be precise, user part of the solution: .SUO file), they are not stored inside the package. So if you want to send a package to somebody and let them see your breakpoints and visualizers, send the .SLN and .SUO files as well.

Comments

  • Anonymous
    September 20, 2007
    Nice.  Helped me go forward in the new world of SSIS.  Thanks.

  • Anonymous
    September 25, 2008
    Open .dtsx For Debug - Why The Debug Buttons Are Disabled

  • Anonymous
    May 05, 2016
    When saw I was being redirected to a Microsoft page searching for 'SSIS debug' I feared the worst, but was pleasantly surprised by your concise description and tight writing style.

  • Anonymous
    June 22, 2016
    thanks - 9 years after your post you've helped me!

  • Anonymous
    September 07, 2016
    Just the article I was looking for...