February 5, 2024 at 4:35 pm
Hi,
I used to work a lot with MS SSIS ETL but I have been away 5 years now - working with Sql Server, DB2 and Informatica PowerCenter ETL
Now I have an assignment with a customer who wants me to convert their PowerCenter ETL to SSIS due to company strategic policy.
I installed Visual Studio Professional 22 and I tried to include SSDT, BIDS, or what ever is the official name now.
But I can not create a SSDT project/Solution- it is not offered as an alternative in the File/New/Project...File....
Can you guys please help me,
Ville
I attached my installation choices and the VS Help/About
February 5, 2024 at 4:41 pm
After installing VS2022, go to Extensions and install the
SQL Server Integration Services Projects 2022
extension. That should get you going.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 5, 2024 at 4:43 pm
SSDT, which is just database projects (now) is installed via the installer. Open the Visual Studio Installer and then modify your Visual Studio Install to add "Data storage and processing" in "Other Toolsets".
If you want SSIS, that's an extension and is installed from the Extensions Marketplace from within Visual Studio (Extensions -> Manage Extensions).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 5, 2024 at 5:06 pm
Hi there Phil and Tom
Like I show in the attachment, I have 'SQL Server Integration Services Projects 2022' and 'SSDT' (which I understood is not what I am looking for)
I also had 'Data storage and processing' checked in the installer
Why do these tool installations need to be so difficult nowadays:)
I'd only want to redo the ETL with SSIS....
I am sorry to admit but I did not get it yet
Ville
February 5, 2024 at 5:20 pm
So if you select File/New Project and then type 'SSIS' in the search bar, what do you see?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 5, 2024 at 5:46 pm
Phil...
Thank you
Now I have my SSIS Project/Solution created!
Why I wasn't able to do so before - maybe I just did not know to write SSIS in the search bar
Ville
February 5, 2024 at 6:12 pm
Great, problem solved.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply