May 18, 2021 at 4:27 pm
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!
May 18, 2021 at 4:29 pm
Is the package part of an SSIS project? It needs to be. Open the project in SSDT and then open the package.
May 18, 2021 at 4:44 pm
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:
May 18, 2021 at 7:17 pm
Try right-clicking on the Payroll.dtsx package. You should see the option 'View Designer' – select that.
May 18, 2021 at 7:21 pm
Right clicking does not give me an option of View Designer
May 18, 2021 at 8:41 pm
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.
May 19, 2021 at 10:08 am
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.
May 19, 2021 at 1:09 pm
Try this.
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.
May 19, 2021 at 4:00 pm
I had to uninstall everything to clean things up. Should I install VS before the link you posted?
May 19, 2021 at 6:05 pm
The link you supplied worked with no problems.... thanks!
May 19, 2021 at 9:35 pm
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?
May 20, 2021 at 8:29 am
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.
May 20, 2021 at 1:20 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy