question

SQLKing-6706 avatar image
0 Votes"
SQLKing-6706 asked ·

How do you build SSIS packages in VS 2019

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
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered ·

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.










· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

FelixP-2774 avatar image
0 Votes"
FelixP-2774 answered ·

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?

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.