Saturday, February 04, 2017

1. Import SSIS Package into SQL Server

2. Connect Integration services using SSMS (SQL Server Management Studio)

3. Select Package Location from “File System”

4 DerivedColumn Package imported into MSDB( where the package is stored)

5 Execute Package Utiltiy to DerivedColumn Package to test to export data into Excel file D:\Temp\DerivedColumn.xls

6 Create a Job to run the Package at scheduled time

7 SSIS DerivedColumn job has been successfully executed and output on excel file location D:\Temp\DerivedColumn.xls

No comments: