SSIS Tutorial Part 21-How to Load Data to Pre-Formatted or Template Excel File in SSIS Package

In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to load the data from SQL Server Table to already formatted Excel sheet.
Let's suppose that our business users has prepare an Excel file with pre formatted information such as Log of company on top,
Contact information and company name etc. and have colored the header and sheet as per company standards.

They want us to write the data right after their information in this Excel Sheet so this can be send to Customer on daily basis.

The video covers following Items to prepare an SSIS  Package for this requirement

  1. How to create Excel Template or Pre-Formatted Report that we will be using in SSIS Package
  2. How to create a Template folder in which this initial file will be save
  3. How to write data from SQL Server Table to Excel Destination 
  4. How to Copy Template Excel file to Destination Folder and rename by adding DateTime to it
  5. How to Use Functions such as GETGATE(), Substring(), Replace in SSIS Package
  6. How to use Variables and Expressions in SSIS Package