Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [visual-studio-2012]

23 questions
14
votes
3 answers

sqlpackage.exe ignoring BlockOnPossibleDataLoss?

I have a dacpac that has set the BlockOnPossibleDataLoss set to false, however the deployment is blocked when I run it with sqlpackage.exe, telling me "The column [a] is being dropped, data loss could occur." However when I use the exact same…
nojetlag
  • 2,927
  • 9
  • 34
  • 42
6
votes
1 answer

Any Tricks to Better Identify Disabled SSIS Elements?

Does anyone have any tricks they care to share that will help better identify disabled elements within SSIS packages? Ideally there's some manner to adjust the text color to red or or something along those lines, but the default behavior seems…
John Eisbrener
  • 9,547
  • 6
  • 31
  • 65
5
votes
4 answers

Script component source won't load when click "Edit Script..."

I'm working on an SSIS package in Visual Studio 2013. For any script component throughout the package, if I double-click on it and then click the "Edit Script..." button, Visual Studio 2012 opens but no editor window loads. It's just an empty window…
Chris Pratt
  • 311
  • 2
  • 3
  • 12
4
votes
3 answers

SQL Server 2012 - Insufficient memory to continue the execution of the program. (mscorlib)

I have a sql file, which is up to 180 Mb. When I try to open and execute it on Microsoft SQL Server Managment Studio 2012, I am getting this error. . What do do ? I researched on Google. And there were a few answers. One solution they say was…
Romo Daneghyan
  • 143
  • 1
  • 1
  • 3
4
votes
1 answer

SQL Server is configured to allow remote connections

I use SQL Server 2012 and SSAS Tabular Mode (My Instance Name Is MSSQLSERVER2012T) Then I download AdventureWorks Tabular Model SQL Server 2012 From This link I open it with Visual Studio 2010 and configure my Instance Name like this picture…
Ardalan Shahgholi
  • 457
  • 2
  • 8
  • 20
3
votes
2 answers

Where can I get the master.dacpac file for SQL Server 2012?

I am using Visual Studio 2012 Professional with SQL Server Data Tools with a SQL Server 2012 standard edition database instance. I have been unable to locate a master.dacpac file on either my development machine or on the server hosting the SQL…
Mark Freeman
  • 2,293
  • 5
  • 32
  • 54
3
votes
1 answer

VS2012 setup spoils SQL Server 2012 Data Tools for everybody or just me?

On Windows 7 Prof I have installed SQL Server 2012 R2 with, as I am pretty well remember, client tools. Then, I tried to install Visual Studio 2013 Ultimate but failed. Then I've installed VS2012 Prof (30-day trial). Now, on launching SQL Server…
Fulproof
  • 1,392
  • 2
  • 26
  • 36
3
votes
1 answer

'Connection not found' error thrown at end of task, after the package has successfully used the connection it refers to as missing

Sorry for the long title and this long question! I'll set the scene. I'm fairly new to VS and SSIS. I have created several SSIS packages, basically a package for retrieving data and creating a csv file, getCSV.dtsx, and another to Load said csv file…
TheOriginal
  • 41
  • 6
2
votes
2 answers

Can I default to T-SQL only view in VS 2012?

When creating new tables in a database project in VS 2012, opened sql files default to a split view. One is the T-SQL text editor view, and the other is the Design view. I've never used the design view, and probably never will. I just prefer the…
blachniet
  • 121
  • 3
2
votes
0 answers

SQL71561 Error on Schema compare after initial import from database

I have created a new sql server project with SSDT 2012, then I went to import an existing database and it created all my scripts. After that I did a schema compare between the project and the database I just imported the objects from. And I got tons…
nojetlag
  • 2,927
  • 9
  • 34
  • 42
1
vote
0 answers

SQL Server Comparison

I am merging two different versions of a database. I want to add some specific fields from source database to destination, so I used Visual Studio to do that. It does the job quite well but only table level, which means it checks for the table if…
Kirk
  • 111
  • 4
1
vote
2 answers

SSIS Failed to start project

I've created sereral SSIS packages in Visual Studio 2012 and they can be executed without any problems. For a project I'm working on I generate packages using BIML. In my BIML script I create a package for each databaseview in two defines…
Ruud van de Beeten
  • 588
  • 1
  • 7
  • 17
1
vote
1 answer

How should I set up SQL Server Login permissions for access to website on a different server using Windows Authentication

I know this question doesn't really belong here, but I posted on the MS IIS Site and am still hoping for a reply. I have an intranet site created with .NET Framework 4.0 in Visual Studio 2012 and I used the VS2012 publish command with "Window…
Dan B
  • 205
  • 1
  • 2
  • 8
1
vote
1 answer

Is it possible to restrict SQL Server DB_Owner when connecting using SQL Server Mgt Studio?

Here is the back story. A developer created an EXE program. The exe program has the ability to access a SQL Servre database. In order to do that we create an Active Directory group. Let's call this group AppAdmin. The EXE program use windows…
BobNoobGuy
  • 413
  • 3
  • 7
  • 11
1
vote
2 answers

Microsoft SQL Server how can i detach localdb to run on any computer

I am working on a personal project and have implemented a database system using the Entity Framework code first tutorial on msdn, link below, http://msdn.microsoft.com/en-gb/data/jj193542 I am running Visual Studio 2012 and the database has been…
KingSpread
  • 13
  • 1
  • 3
1
2