Saturday, February 04, 2017

Upgrades from Earlier Versions to SQL Server 2016

You can upgrade to SQL Server 2016 supports upgrade from the following versions of SQL Server:
•SQL Server 2008 SP3 or later
•SQL Server 2008 R2 SP2 or later
•SQL Server 2012 SP2 or later
•SQL Server 2014 or later
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