Using SQL Profiler on SSIS package 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
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.