SSIS Tutorial Part 17 - Create Excel File with DateTime On Each Package Execution in SSIS Package

In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to create An Excel file with date-time on each package execution. This is important when we want to run our package multiple times in a days and
don't want to append the data to already existing Excel File.

The video will cover following Items

1. How to Load Data from SQL Server Table to Excel Sheet
2. How to use Data Conversion Transformation to Convert SQL Data To Excel Data Types
3. How to use OLE DB Source and Excel Destination in SSIS Package
4. How to use Variables in SSIS Package
5. How to Write Expressions to get Date-time in SSIS Package
6. How to use variable in Excel Connection Manager to provide File Name with Date-time
7. How to use DelayValidation property in SSIS Package to ignore prevalidation in SSIS Package

Expressions used in the SSIS Package to Create Excel file with Date Time:

@[User::DestinationFolder]+"RegionalCustomer_"+Replace(Replace(Substring((DT_WSTR,30)GETDATE(),1,16),":","_"),"-","_")+".xlsx"

Create Excel File with DateTime On Each Package Execution in SSIS Package - SQL Server Integration Services ( SSIS ) Tutorial

Check out our other related posts/videos on Excel Source And Excel Destination

• How to Load Multiple Sheets to a SQL Server Table in SSIS Package?
• How to Load Data Excel File to SQL Server Table and Solve Data Conversion Issues?
• How to Load Multiple Sheets From Multiple Excel Files to Different Tables in SSIS Package?
• How to Load Data to Pre-Formatted Excel Sheet (Excel Report) in SSIS Package?
• How would you split Full Address Column into Multiple Columns in SSIS Package?
• How to Read Alpha Numeric Data from Excel Source File