Unable to open .dtsx file in Design View
-
I saved an SSIS package and next day went to open it in Visual Studio but my .dtsx file only opens with what appears to be XML markup. Any ideas what could be wrong? Thanks!
- This topic was modified 3 years, 6 months ago by DaveBriCam.
-
Is the package part of an SSIS project? It needs to be. Open the project in SSDT and then open the package.
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 -
I have SSDT open but I don't know from there what to open. I see a solution .sln file but when I open it here's what I see:
-
Try right-clicking on the Payroll.dtsx package. You should see the option 'View Designer' – select that.
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 -
Right clicking does not give me an option of View Designer
- DaveBriCam wrote:
Right clicking does not give me an option of View Designer
Which version of VS are you using?
Did you install the SSIS extensions after installing SSDT? Take a look here for 2019.
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 -
Visual Studio 17 Microsoft SQL Server Data Tools for Visual Studio 2017 SSDT Version 15.9.30
I don't remember installing any extensions, but I may have, all I know is it was working fine for building a rather involved package that was working well, and suddenly I can't do anything with the SSIS product.
-
I suggest you run this: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15#ssdt-for-vs-2017-standalone-installer
making sure you select 'SQL Server Integration Services' during installation. I'm not sure whether you have to uninstall your existing SSDT first.
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 -
Try this.
- In VS create a new SSIS project/solution.
- Add the existing .dtsx to the new solution
- Then try opening the package by double clicking it in Solution Explorer.
You also have to make sure the SSIS package version and the version of VS are compatible. For example, I have to use VS10 to open SQL Server 2012 SSIS packages.
-
I had to uninstall everything to clean things up. Should I install VS before the link you posted?
- DaveBriCam wrote:
I had to uninstall everything to clean things up. Should I install VS before the link you posted?
Assuming you have full VS Pro, yes.
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 -
The link you supplied worked with no problems.... thanks!
-
One more issue arose. I cannot edit my C# Scripts... I hit the button and C# won't launch... I ran the repair on VS 17 and restarted my machine and the problem persists. Any ideas?
- DaveBriCam wrote:
One more issue arose. I cannot edit my C# Scripts... I hit the button and C# won't launch... I ran the repair on VS 17 and restarted my machine and the problem persists. Any ideas?
I've had this happen to me several times. It's a real showstopper and (you're not going to like this one bit!) the only way I was able to resolve it was to do a full uninstall/reinstall of SSDT. As far as I remember, I did not have to reinstall VS as well, which saves a few hours.
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 -
Did an uninstall/reinstall of SSDT. Still can't see or edit my C# script. I uninstalled VS. What is the best link to reinstall VS & SSDT?
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply