Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to use SQL Server Profiler to trace a running SSIS package? I tried to do that, but all I can see in the trace is executing dp_sqlagent_... and the other internal commands! None of the tables/script that the package is working on displayed in the trace.

I tested different trace templates but had not much lock. Have you got any experience in this area?

Thank you.

Cheers, Nazila

share|improve this question
up vote 4 down vote accepted

If you aren't seeing the activity in your trace, it may not be getting that far. You'll want to turn up some logging for your SSIS package.

share|improve this answer
For any other person benefit, as Eric mentioned above, to be able to trace a SSIS package in SQL Server Profiler, you need to first set the SSIS loggings int the package. Follow the steps below: Open the SSIS solution > Clik on SSIS menu > Add a new log while you choose the Provider Type as 'SSIS log Provider for Windows Event log' > Click on Details tab and select any events you are interested in logging > Save the log entry. – Sky Aug 13 '12 at 4:15

BIDS Helper has a built-in package profiling tool which is pretty cool when running the package interactively. It's available (once you've installed BIDS Helper) by right-clicking the package and then 'Execute and Visualize Performance'.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.