• Don't like the cursor. Can you run something like this?

    SELECT o.name,

    ddps.row_count

    FROM sys.indexes AS i

    INNER JOIN sys.objects AS o ON i.OBJECT_ID = o.OBJECT_ID

    INNER JOIN sys.dm_db_partition_stats AS ddps ON i.OBJECT_ID = ddps.OBJECT_ID

    AND i.index_id = ddps.index_id

    WHERE i.index_id < 2 AND o.is_ms_shipped = 0 ORDER BY o.NAME

    If yes, use it as an OLEDB source in a dataflow. Then you can fire the results where you want.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.