Using SSIS ( SQL Server Integration Service) what are the possible ways to update the table?

To update the table using SSIS the possible ways are:

  • Use a SQL command
  • Use a staging table
  • Use Cache
  • Use the Script Task
  • Use full database name for updating if MSSQL is used