Simon
4Penny.net
Points: 7383

5/25/2021 9:10:56 AM

Creating SSIS Packages from Visual Studio 2019

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

This is a short primer on how to create SSIS Packages from Visual Studio 2019. But first, some background...

Microsoft’s tool for developing Integration Services projects is named differently in different versions of the Visual Studio. For example, for the SQL Server 2008/2008R2 integration services, this tool was VS 2008’s Business Intelligence Development Studio (BIDS) and came with the SQL Server installation media. In VS 2010, the tool was renamed as the SQL Server Data Tools (SSDT) and shipped as a part of the SQL Server 2012 installation media.

In VS 2012/2013, this tool was slightly renamed as SSDT-BI and needed a separate download. In VS 2015, it was called SSDT and needed a separate download.

In VS 2017, this tool could be installed during the VS installation. It is worth mentioning that BIDS, SSDT-BI, and SSDT can be used not only for working with SSIS projects, but also SQL Server Analytical Services and SQL Server Reporting Services projects. Additionally, it is important to note that SSDT is backward compatible, which means that projects designed on the newer versions of SSDT can run on older versions of SQL Server.

So... on to VS 2019

4Penny.net
Version: Unknown or N/A
Section: SQL Scripts,SSRS,SQL for Beginners
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3