Using SQL Profiler on SSIS package

profilerssis

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

Best Answer

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.

Related Question