1.

Write different ways of updating a table when SSIS (SQL Server Integration Services) is being used.

Answer»

In ORDER to update a table in SSIS, the following steps can be taken:  

  • Use the SQL command.
  • For storing stage DATA, use staging tables.
  • Keep data in a cache that occupies a limited amount of space and needs to be refreshed frequently.
  • Scripts can be used for scheduling tasks.
  • When UPDATING MSSQL, use the full database NAME.


Discussion

No Comment Found

Related InterviewSolutions