I have just currently switched over from DTS to SSIS. This particular package that I work on has a data flow task that exports a SQL table to MS Access. However, the export takes a long time compared to DTS and I don't know how many rows are copied since the SSIS interface no longer gives me the status of rows copied at a given time.
In DTS, I like how SQL gives you status and rows copied in brackets such as "running (2000)", so when it is stuck I know how to react. Does SSIS have this kind of interface during execution? The execution progress doesn't give me anything except for the message "phase is starting"
Thanks for your help!