Saturday, February 04, 2017

How to Import SSIS Package into SQL Server

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