This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Hello, I have VS 2019 installed and need to open and view SSIS dtsx packages on seeing exactly what they're doing.
Believe I'll need SSDT to do this which how do I know if this is installed and if not how?
I went to https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver16#ssdt-for-visual-studio-2019 (though mentions VS 2022) and opened my VS Installer but doesn't show up similar and can't seem to locate it.
Or if I'm not understanding and/or need something different please let me know.
Thanks in advance.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Hello @techresearch7777777 ,
Welcome to Microsoft Q&A forum.
After opening VS Installer, you can click Modify, choose Workloads tab, check Data storage and processing workload, on the right, you should see SQL Server Data Tools, check it too. If you still cannot find it, try to switch to Individual components tab, search SQL Server Data Tools, you won’t miss it.
How to know if SSDT is installed and if not how?
After you check the SQL Server Data Tools component in VS Installer, don’t forget to click Modify button to install it. If it has been installed, the next time you open VS Installer, you will see that it has been checked, and if you open Visual Studio, you will see related database project templates listed in the create a new project window.
I have VS 2019 installed and need to open and view SSIS dtsx packages on seeing exactly what they’re doing.
You may also need to install SSIS extension in VS 2019, please try to open VS, click Extensions, Manage Extensions, Online, search for SQL Server Integration Services Projects extension, click Download and close VS to install it.
Best Regards,
Tianyu
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hello @techresearch7777777 ,
We have not heard from you for a couple of days. May I know if you can now successfully open and view SSIS dtsx packages?
Feel free to let us know if you have any further concerns:)
Thanks very much Tianyu for the excellent detailed step by steps and screenshots.
After going through them looks like my VS does have the components above you provided...
Next is how do I view the inner workings and what they're doing of existing SSIS Packages within a SQL Server instance?
I tried to go through [Integration Services Project1] -> [SSIS Packages] (Right Click) -> [Add Existing Package] :
I'm confused why both navigation methods I describe here don't match what they are listing...any help please?
Thanks in advance.
Hello @techresearch7777777 ,
If you want to add packages in SSISDB(instead of in SSIS service), you may need to create and use "Integration Services Import Project Wizard" project(instead of "Integration Services Project").
Looks like I successfully was able to Import and analyze the Packages via... "Integration Services Import Project Wizard" project(instead of "Integration Services Project").
Thank you so much Tianyu Sun-MSFT, really appreciate it.
Believe I'll need SSDT to do this which how do I know if this is installed and if not how?
You want to know?
Start Visual Studio and if you have the option to create a new SSIS project, then SSIS is installed, otherwise not: Install it.