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?
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?
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.