Checking Details
If long-running transactions exist in the source database, the check task will report a warning. Users may choose to ignore the warning and proceed; however, it is recommended that they address the long-running transaction issue before initiating Data Transfer Service (DTS) tasks.
Fixing Methods
Handle long-running transactions in the source database before initiating DTS tasks.