Integration Services (SSIS) Migration from SQL server 2008 to 2012

The Business Intelligence Development Studio (BIDs) is replaced by the SQL Server Data Tools (SSDT). 

SQL Server 2012 SSIS offers a wizard for upgrading most of the solution components, but a few settings may be needed to be changed manually.

The wizard appears when you open a SQL Server 2008 package on the SQL Server data tools.

The migration of the integration services (SSIS) packages Aas below :

1. Open the solution (sln) file with the packages to migrate
2. The Visual Studio Conversion wizard appears. It is very simple and after a few next's pressed(read the details carefully before pressing the next button), the Package Management options appear.
3. In the Package Management options select validate upgraded packages, so that
4. the packages are validated and only the ones that pass validation are saved.
5. Disable Ignore configurations, so that the configurations are validated during the upgrade process
6. Test each package and verify that it is working as expected.

 If you don't have Old BI solution in place, can follow the below step   click here    to create solution and convert it to deployment model.