Stack Overflow
Stack Overflow

Questions tagged [sql-server-2012-datatools]

Microsoft SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the SQL Server Object Explorer in VS to easily create or edit database objects and data, or execute queries.

84 questions
58
votes
5 answers

What about Sql Server Data Tools for VS2012 being incompatible with Sql Server 2012?

In what seems to be a very odd turn, I am trying to create a Sql Database project in Visual Studio 2012, and am getting this nutty error: And clicking on either link leads to a Page Not Found at Microsoft.com, which is odd in itself. From the bare…
Cyberherbalist
  • 12,061
  • 17
  • 83
  • 121
50
votes
12 answers

Update target button is disabled after schema comparison

I have created database project using VS 2012. Once the schema comparison is done, the update target button should be enabled to sync with target, but it's not getting enabled. How can I fix this? I'm using VS 2012 with SP 3, SQL Server 2012,
Aruna
  • 1,962
  • 4
  • 25
  • 50
26
votes
7 answers

The report definition has an invalid target namespace rsInvalidReportDefinition

I have created a ReportProject with Visual Studio data tools 2015. When I create a report.rdl file using the report wizard, the rdl file has schema for 2016. My reporting server is of version 12.0.4213.0. How can I create a report.rdl which is…
Anirudhan J
  • 2,072
  • 6
  • 27
  • 45
8
votes
2 answers

Trigger is blocking database project publish

I have a Visual Studio 2012 database project, containing my database schema. In a post deployment script, I automatically create a number of triggers responsible for logging changes to the table's data. Unfortunately, when I subsequently modify the…
AaronSieb
  • 8,106
  • 8
  • 39
  • 58
7
votes
5 answers

SSRS Hiding the textbox in a table cell causes the borders to disappear

I have a report with a table in it. And each table cell has borders around it. The problem I'm experiencing is that if I hide the textbox in any of the cells, the borders also disappear. I want the textbox to hide but still show the borders. The…
iDesi
  • 692
  • 1
  • 10
  • 19
6
votes
3 answers

How to change the connection in Sql Server Data Tools Editor in Visual Studio

My goal is to keep SQL Server stored procedures under source control. I also want to stop using SQL Server Management Studio and use only Visual Studio for SQL related development. I've added a new SQL Server Database project to my solution. I have…
Lucian
  • 3,981
  • 5
  • 30
  • 34
6
votes
1 answer

SQL Server 2012 DataTools + Visual Studio 2012 = An incompatible DacFx version is installed

I'm going crazy, trying to use SSDT in Visual Studio 2012. I created a database but I can't add tables etc. because of this error. I installed: Visual Studio 2012 Ultimate SQL Server 2012 Express x64 with Advanced Services, plus…
DioBrando
  • 987
  • 3
  • 10
  • 22
5
votes
1 answer

SSDT - Ignoring partition function changes

I'm trying to publish a database project, which also contains a partition function. My destination databases have different (date) values which I do not wish to modify, although SSDT/SqlPackage always attempts to re-create the Partition Function and…
0xAD
  • 141
  • 2
  • 10
5
votes
1 answer

Why is UPDATE considered a SQL System Function with respect to color theme?

I am using SQL Server Management Studio 2012 and am trying to update the Fonts and Colors using my Visual Studio dark theme settings and in doing so, I've found something a bit weird: UPDATE is being colored with the color assigned to the SQL System…
Code Maverick
  • 20,171
  • 12
  • 62
  • 114
4
votes
1 answer

Unable to use SSIS's SSDT in VS2010 / SQL Server2012

I have a full version of SqlServer 2012 installed on my local machine and have installed SSDT from the installation package (and updates) I've then opened the SSDT visual studio application and installed the SSDT package from Microsoft which appears…
danielpiestrak
  • 5,279
  • 3
  • 30
  • 29
4
votes
2 answers

Creating SQL Agent JOBs in SQL Server 2012 Database Projects from VS 2012

I am working on Visual Studio 2012 with Update 2 + SQL Server Data Tools and I am able work on the SQL Server Database Projects. How do I create/add new SQL Agent JOB into this database project? Because if I click Add - New Item... I don't see…
Prabhat
  • 4,164
  • 4
  • 17
  • 12
3
votes
0 answers

DTS that uses Microsoft.Office.Interop.Excel in a JOB does not run

I have developed a DTS with SQL Data Tools that has a "Script task" that uses Microsoft.Office.Interop.Excel, the main purpose of this is to create a XLS file, when i debug the solution, it runs perfect, but when i programmed the DTS in a JOB, it…
EGSL
  • 141
  • 8
3
votes
1 answer

Optionally including scripts in SQL Server Projects 2012

I am building a SQL Publish Script that will be used to generate a database to our internal servers, and then used externally by our client. The problem I have is that our internal script will automate quite a few things for us, in which the actual…
Dominic Zukiewicz
  • 8,258
  • 8
  • 43
  • 61
3
votes
1 answer

Why are SSIS custom tasks not showing in SSIS Toolbox?

I have some custom control flow and data flow tasks that are not showing up in the SSIS Toolbox. When I open a package in SSDT containing the custom tasks I get several errors loading the package. Error loading MyModuleTemplate1.dtsx: Cannot create…
Rich
  • 1,895
  • 3
  • 26
  • 35
3
votes
1 answer

Is visual studio 2012 ssis shell dragging objects on canvas shaky or impossible?

In a new version of Visual Studio 2012 (ssis) shell - when dragging objects on the canvas is extremely "shaky" or impossible to move the objects. They either do not follow the mouse or shake/snap to random points. I only found two similar…
bbaley
  • 199
  • 6
  • 22
1
2 3 4 5 6