Update 5 Jun. 2023 – General Availability (GA) release Microsoft released Version 1.0 (General Availability (GA) release) of the SQL Server Integration Services extension for Visual Studio 2022. Update 24 Nov. 2022 – Public preview released Microsoft added a public preview of the SQL Server Integration Services Projects 2022 to the Visual Studio marketplace, which … Read more
Answer: Microsoft now has an official NuGet package (see blog post). Old answer, prior to August 2016; provided in case the NuGet package doesn’t work for you: Install dacframework.msi (x86|x64) Install SQLDOM.MSI (x86|x64) Install SQLLS.MSI (x86|x64) Install SQLSysClrTypes.msi (x86|x64) Install SSDTBuildUtilities.msi (from the “Administrator Install Point” as setup in step 3 here) Done! Source: Headless … Read more
One other possibility is that the schema you have used in your view/table etc does not exist in the project. You may need to add the schema to the VS Database Project. Right Click the project and Add > New Item > Schema
If you have the solution > properties > TargetServerVersion set to SQL Server 2008 R2, 2012 or 2014 and then upload the RDL from the bin folder instead of the project folder, it should work. I was getting the same error and that solved it.
The answer from Nick is very helpful, but I still failed at SSDT-Setup-ENU.exe /repair with the same error Error 0x800703e9: Failed to execute EXE package.. Then I tried it with a very straightforward way: (Disable UserAccountControl first) copy SSDT-Setup-ENU.exe to c:\temp and execute SSDT-Setup-ENU.exe /layout to download a local copy of the bundle. open C:\temp\redist … Read more
I’ve been working on this myself, and I can tell you it’s not easy. First, to address the reply by JT – you cannot dismiss “versions”, even with declarative updating mechanics that SSDT has. SSDT does a “pretty decent” job (provided you know all the switches and gotchas) of moving any source schema to any … Read more
Welcome to Microsoft Marketing Speak hell. With the 2012 release of SQL Server, the BIDS, Business Intelligence Designer Studio, plugin for Visual Studio was renamed to SSDT, SQL Server Data Tools. SSDT is available for 2010 and 2012. The problem is, there are two different products called SSDT. There is SSDT which replaces the database … Read more
Add a database reference to master: Under the project, right-click References. Select Add database reference…. Select System database. Ensure master is selected. Press OK. Note that it might take a while for VS to update.
This is an issue caused by the ESENT engine relied on by SQL Projects adding in a new file. This is a new feature in Windows 10 Anniversary Edition to avoid data loss, but the fact SQL Projects store the .dbmdl cache file under the project root means this locked file is added to the … Read more