Is it possible to check client statistics (enable client statistics in MS) for an SSIS request (data stream)? I wonder if this information can be caught using any DMV.
I am using SQL Server 2008R2.
My experience was setting up queries before creating the SSIS package. You can also configure the SSIS package after creating it (one example: http://sqlmag.com/sql-server-integration-services/designing-ssis-packages-high-performance ).
, , , SSIS. .