Enable/Disable autocommit in Toad.

Enable/Disable autocommit Toad

You can Enable or Disable the autocommit in Toad.

Utilities -> Toad Options -> Oracle -> Transactions -> Commit After Every Statement.

Enable/Disable autocommit in Toad. was last modified: October 1st, 2017 by Justin Antony

Refresh PowerPivot excel using SSIS

Refresh PowerPivot excel using SSIS

Install the SSIS_EXCEL_REFRESH.EXE in your ETL System and then you will find that component displaying in the SSIS Toolbox.

  1. Configure the EXCEL Refresh Tool
  2. Provide the Path where the Excel resides
  3. Set the Timeout for Refresh
  4. Run the ETL and check the Excel being refreshed.

You can check that by seeing the excel last modified date gets updated.

 

Refresh PowerPivot excel using SSIS was last modified: October 1st, 2017 by Justin Antony