Transfer Logins Task fails with the error message: "Set Database failed. "

Description:

While migrating the logins with the "Transfer Logins Task" from SQL Server Integration Services (SSIS) you might receive the following error message:

Error: Execution failed with the following error: "Set Database failed. ".
Error: Execution failed with the following error: "Value cannot be null. Parameter name: database".