The TOP expression doesn't affect statements that might run because of a trigger. The inserted and deleted tables in the triggers return only the rows that are truly affected by the INSERT, UPDATE, ...
For the configuration of each tab under copy activity, go to the following sections respectively. Connection: Select a SQL server connection from the connection list. If the connection doesn't exist, ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results