1. Connect Integration services using SSMS (SQL Server Management Studio)
2. Select Package Location from “File System”
3 DerivedColumn Package imported into MSDB( where the package is stored)
4. Execute Package Utiltiy to DerivedColumn Package to test to export data into Excel file D:\Temp\DerivedColumn.xls
5. Create a Job to run the Package at scheduled time
6. SSIS DerivedColumn job has been successfully executed and output on excel file location D:\Temp\DerivedColumn.xls
2. Select Package Location from “File System”
3 DerivedColumn Package imported into MSDB( where the package is stored)
4. Execute Package Utiltiy to DerivedColumn Package to test to export data into Excel file D:\Temp\DerivedColumn.xls
5. Create a Job to run the Package at scheduled time
6. SSIS DerivedColumn job has been successfully executed and output on excel file location D:\Temp\DerivedColumn.xls