Top "Sql-server-data-tools" questions

SQL Server Data Tools (SSDT) introduces an ubiquitous, declarative model that spans all the phases of database development and maintenance/update inside Visual Studio.

How to publish DACPAC file to a SQL Server database project via SQLPackage.exe of SSDT?

I'm using SSDT for Visual Studio 2012 here and using its command-line tool SQLPackage.exe to publish a .dacpac file. I …

publish database-project sql-server-data-tools dacpac sqlpackage
SSIS Expressions setting two variables

I'm trying to use an "Expression Task" within SSIS to simply initialize/set two variables. This seemingly simple task has …

ssis expression bids sql-server-data-tools ssis-2012
Visual Studio 2012 + Business Intelligence Templates

I got SQL Server 2012 installed on my machine and I have SSDT to create BI projects. Today i installed Visual …

visual-studio-2012 sql-server-data-tools
Using SSDT, how do I resolve SQL71561 errors when I have a view that references objects in a different database?

I have a database project in SSDT and when I import a view that references objects in a different database, …

sql-server sql-server-data-tools
SSIS error: delimiter for column "columnX" is not found

This question was asked here before but the solutions proposed don't seem to be working for me. I'm trying to …

sql ssis etl sql-server-data-tools ssis-2012
SSDT failing to publish: "Unable to connect to master or target server"

I'm attempting to use SSDT to publish to a SQL Server database in Azure. When I do so, I am …

sql azure azure-sql-database sql-server-data-tools
Deploy SQL Server database project (SSDT) via command line

I have a SQL Server Database Project targeting a SQL Server 2012 RC0 database. The project was created in Visual Studio 2010 + …

sql-server visual-studio sql-server-data-tools sqlpackage
Suppress some warnings in SQL Server SSDT

In SQL Server Data Tools, I would like to suppress some, but not all, occurrences of SQL71502 ("--- has an …

sql-server sql-server-data-tools
How do I create the deployment scripts from VS 2012 database projects?

With VS2010 database projects, I could define a target (or not) database, set an action (create script only or create …

sql-server deployment visual-studio-2012 sql-server-data-tools
SSIS Transfer Database task cryptic error message 0x80131500

I am using SSIS with VS2010 (shell) and databases going from SQL Server 2005 (32 bit)to SQL Server 2012 (64 bit). I am …

sql-server sql-server-2005 ssis dts sql-server-data-tools