How do you build SSIS packages in VS 2019

SQLKing 21 Reputation points
2020-06-16T17:32:38.25+00:00

I know SSIS is being phased out but what are they putting in place of it? I installed SQL Server Data Tools which seems great at writing simple T-SQL Statements. What do we do to create more complex projects?

Azure SQL Database
0 comments
Accepted answer
  1. Dave Patrick 426.1K Reputation points MVP
    2020-06-16T17:36:29.69+00:00

    SSIS is not currently supported here on QnA. They're actively answering question in dedicated forums here.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlintegrationservices

    or possibly;

    https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=vssetup

    https://developercommunity.visualstudio.com/spaces/8/index.html

    --please don't forget to Accept as answer if the reply is helpful--

    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. FelixP 86 Reputation points
    2020-06-16T17:41:00.83+00:00

    SSIS remains a thriving technology, and it one of a number of ETL tools (Extract, Transform, Load) offered by Microsoft.

    This page of the docs shows some of the other technologies available https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver15.

    In terms of more complex projects, it’s worth considering what your needs from a tool are. Do you want to be using a graphical tool, or code? Cloud-based or on premises? What are your data sources?

    0 comments