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?
How do you build SSIS packages in VS 2019
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.
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://docs.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?
5 People are following this question.
