SSIS 2008 - 2016 Migration Tips

Learn it in Real time scenarios

1. Benefits

• Data Flow task
• Connection Managers
• Designer Improvements
• Support for multiple versions of SQL Server.

2. SQL Server Versions and Folders 

 3.SQL Server 2016 Service Pack 2 (SP2) Cumulative Update(CU) Builds

 4. SQL Server Components

 5. Other software components

6. SSIS Packages 

• Use Migration wizard
• Choose appropriate Target SQL Server Version.
• Open and build Script tasks -- Found SQL Server Integration Services Script Task.
• Modify the batch files \ Configuration files

 

7. Other

•  Step by step instruction document
• DEV\QA\PROD\DR
• Make the packages independent of regions 
• SSRS reports - Update the report server URL

 

8. Operations

Step 1 : to view Solution Exploer , Check out SSIS Packages

Step 2 Right Click , to Choose Upgrade All Packages

 

 Step 3 , Click Next

 Step 4: Click Next

 Step 5: 

 Step 6 :  Finished

 Step 7 . Error Issue

 Step 8. Right Click

 Step 9. Click Apply and Click Yes and then Click OK.