Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

2 Answers 2

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
add comment

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'.

bidshelper.codeplex.com

share|improve this answer
add comment

Your Answer

 
discard

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.