<div>
<div class="content wysiwyg-content">
Hi<br />
We are in an upgrade project from SQL 2005 to &nbsp;2016. &nbsp;<br />
<br />
I am running SQL Sever 2005 and 2008 and managing with SSMS 2016, we have Visual Studio 2013 Ultimate. <br />
<br />
We want to do SSIS projects. &nbsp;Should we be installing it on VS, SQL ?? &nbsp;What packages? Is there nuget? &nbsp;we ran SSDTSetup and can see posible projects in SSMS but can create we get an error Microsoft.SqlServer.manage<wbr />ment.sdk.s<wbr />fc failed with Class Not Registered<br />
<br />
Any thoughts?<br />
<br />
Thank you
</div>
</div>


Hi
We are in an upgrade project from SQL 2005 to  2016.  

I am running SQL Sever 2005 and 2008 and managing with SSMS 2016, we have Visual Studio 2013 Ultimate. 

We want to do SSIS projects.  Should we be installing it on VS, SQL ??  What packages? Is there nuget?  we ran SSDTSetup and can see posible projects in SSMS but can create we get an error Microsoft.SqlServer.management.sdk.sfc failed with Class Not Registered

Any thoughts?

Thank you

Need SSIS project

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.

SSIS

Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft. It is used to develop computer programs for Microsoft Windows, as well as web sites, web applications and web services. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Windows Store and Microsoft Silverlight. It can produce both native code and managed code.