Right way and SSIS sql server integration services projects instalation

Question

Post reply

Right way and SSIS sql server integration services projects instalation

joaofigu

SSC Enthusiast

Points: 174
More actions
March 2, 2023 at 3:19 pm

#4156028

Hi there, i ´m new in this roads, and i don´t see the right topic to wrote this .
I'm connected to an instance on a standard SQL 2019 server. I installed SQL Dev 2019 on my pc and visual studio 2022 community, but I can't install ssis because during the installation it doesn't recognize the visual studio instance to continue the installation. can u help me? thanks.
I take the opportunity to explain that I wanted to explore ssis because I'm migrating databases from Access to SQL, but in Access I can use code to do automatic inputs and information processing and reporting with a basic front end, and I wanted to have the same thing but using tables in SQL (greater capacity and speed) am I going the right way?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Emperor100 SSCrazy Points: 2173 More actions · Answer 1

Installing only Visual Studio will not help. You need to use SSDT Tools to open any SSIS package.

https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver16

Once the installation is complete, use SSDT to create a new package or open an existing one.

=======================================================================

joaofigu SSC Enthusiast Points: 174 More actions · Answer 2

Hello, thanks for the feedback. i have the tool instaled but still can´t install th ssis.

thanks.

Ant-Green SSC Guru Points: 113498 More actions · Answer 3

Since Visual Studio 2019, the SSIS/SSAS/SSRS projects are completly seperated from SSDT.

You need to go via the marketplace and download the individual projects (more so for SSIS) or use the add VISX if you have the VISX files.

Note that SSIS at the moment only support Visual Studio 2019 (looking at the marketplace), so I would go and use VS2019 and not VS2022

https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects

https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio

joaofigu SSC Enthusiast Points: 174 More actions · Answer 4

Thanks!! it work, i had to download de Vixs files again from VS2022 but it works.!!

thanks!

Michael L John One Orange Chip Points: 27053 More actions · Answer 5

joaofigu wrote:

I take the opportunity to explain that I wanted to explore ssis because I'm migrating databases from Access to SQL, but in Access I can use code to do automatic inputs and information processing and reporting with a basic front end, and I wanted to have the same thing but using tables in SQL (greater capacity and speed) am I going the right way?

Define what an "Automatic Input" and "information processing " may consist of.

Something tells me that SSIS is overkill for what you may need to do.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/