Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [visual-studio-2017]

21 questions
7
votes
1 answer

SSIS Package Not Being Deployed

I have an issue with an SSIS package, that when deployed via VS2017 to the integration services catalog is not actually being deployed. This is an individual package deployment, and not a project deployment. There are no error messages, and the…
SteveG
  • 71
  • 3
4
votes
2 answers

How to delete stored procedures from a database project and have that reflect on the server?

I have a Visual Studio database project with several stored procedures. I deleted one of them and then published the project. But the SP was still present on the published database and I had to delete manually. I would want the VS project to be the…
Zach Smith
  • 2,430
  • 13
  • 34
  • 65
3
votes
1 answer

Error publishing SQLCLR C# Function using Visual Studio 2017

I'm trying to (learn) publish a SQLCLR function using Visual Studio 2017. (It's a simple function that sends an email.) As a reference I used this articles on CodeProject and MSSQLTips: Create, Run, Debug and Deploy SQL CLR Function with Visual…
McNets
  • 23,979
  • 11
  • 51
  • 89
3
votes
0 answers

View(df) in R throw (function(x, df1, df2, ncp, log = FALSE))

I connected R with SQL Server (in Visual Studio 2017) the connection succeeded this is Setting.R settings <- as.environment(list()) dbConnection1 <- 'Driver={SQL Server};Server= (local);Database=SaVeITDB;Trusted_Connection=yes' this is…
Rand alrand
  • 45
  • 6
3
votes
2 answers

Database version is higher than SSMS and throwing error when attempted to create table

I have installed VS 2017. After that I have installed SQL Server 2014. Whenever I create a DB using SSMS and attempt to create a table it returns the following error: This backend version is not supported to design database diagrams or tables.…
TheDeparted
  • 33
  • 1
  • 1
  • 7
3
votes
3 answers

Installation of Microsoft SQL Server Data Tools Hangs

I'm attempting to install SQL Server Data Tools, but the installation is hanging. It had an error the first attempt; and I've restarted the machine (as that seems to help in those scenarios). Now it just sits there on the tools for Visual Studio…
ChrisHDog
  • 183
  • 1
  • 7
3
votes
1 answer

how do you reference server logins from a visual Studio database project?

I'm looking for a way to move all our SQL Server databases (on one server) into source control. I tried creating a solution, and then adding VS database projects to the solution that correspond to the SQL Server databases. As I was creating the…
Zach Smith
  • 2,430
  • 13
  • 34
  • 65
2
votes
3 answers

Is it possible to edit data inside an unencrypted SQL Server backup file (*.bak) without SSMS?

I have found out that there is a difference error (Remaining Qty <> (Purchase - Sales)) in one of the items in my database. There are more than 5000 items and more than 100,000 transactions has happened up to now. Same procedure runs every time for…
lakshitha dilhan
  • 39
  • 5
2
votes
2 answers

SSIS Script transform package won't compile when deployed to dev [Visual Studio 2017]

I have visual studio 2017. I have a script transform that I can run locally just fine, however when I deploy to the Integration Services Catalog on the dev server and run it, it fails with the following error: 'package name':Error: Failed to…
Sixsmith
  • 23
  • 4
2
votes
0 answers

What is the .sqlproj.user file, and how is it created?

I want to move a .sln file to a directory above where it is currently located (because right now it's in a project directory, which isn't semantically correct). The project is called 'pName', and within the project there is a file…
Zach Smith
  • 2,430
  • 13
  • 34
  • 65
1
vote
0 answers

SSIS package runs fine in VS 2017, but in VS 2022 I get Microsoft.ACE.OLEDB.12.0 provider is not registered

I am able to run an SSIS package from my machine without issue in Visual Studio 2017, but I am unable to run the same SSIS package on the same machine in Visual Studio 2022. I am running Windows 10 Enterprise 64 bit. The error message when trying to…
Juan Velez
  • 3,303
  • 19
  • 57
  • 75
1
vote
1 answer

connect SQL server file (mdf) with R tool

It's possible to connect SQL server file (mdf) with R tool in visual studio 2017? I tried that many times but the connection failed. From visual studio2017, I want to connect R with Sql server database. I created R project then from R (tools--> Data…
Rawan
  • 7
  • 1
1
vote
1 answer

Connecting MySQL to Visual Studio 2017

For the life of me, I cannot get the MySQL for Visual Force connector to work in VS. I just want to be able to add a MySQL database as a database connection in VS so I can build an integration. I have the community version of VS 2017. I have…
Chance
  • 174
  • 3
  • 10
0
votes
0 answers

SSIS Foreach Loop Container Hangs When More than 2 Variables are Assigned

I have a 2017 SSIS package with a Foreach Loop Container that iterates over an ADO Recordset. The iteration works fine when I assign only 1 or 2 result columns to variables; however, if I try to assign 3 or more result columns to variables then the…
Phil Jacobs
  • 1
  • 2
0
votes
0 answers

In a Visual Studio VB.Net project, how can SQL connection parameters be saved for repeated use?

When working with SQL files in a VB.Net project, how can the connection parameters be saved for easier development? There are SQL files in the project, to hold queries for use in the app. When one of the files is opened for editing & testing, the…
spinjector
  • 147
  • 1
  • 8
1
2