How to debug SSIS Package - SQL 2008

How to debug开发者_StackOverflow中文版 SSIS Package - SQL 2008? I am calling the package from C# Code. But the package is not executing. I want to debug the SSIS Package and trace the paramter values.

---

Usually, you debug packages in BIDS, although you can directly attach a debugger to the host processes too, if you're doing something special. Does this not do what you need?

Alternatively, use 'manual debugging', i.e. message boxes, writing the parameter values to a log file, etc.

---

Did you know that you can start package execution from the command line:

"c:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /File <your package name>

So for debugging, go to your project's Properties | Debug. Set the 'Start Action' to c:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe. Set the 'Command line arguments' to /File (your package name).

Set some breakpoints in your code, and F5 to run your project. If all goes well, it should stop when it encounters your breakpoint.

I do this often, it works quite well.