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: