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
0
votes
1 answer

Deploy SSIS Packages developed using SQL Server Data Tools for Visual Studio 2012

So I have a suite of SSIS packages that we created using Visual Studio 2008 and are currently deployed on a SQL Server 2008R2 instance. However, I would like to upgrade these to 2012 via SQL Server Data Tools for Visual Studio 2012 which is easy…
0
votes
1 answer

Getting error loading data into the MS Access using SSIS

Message Executed as user: WORKGROUP\REPORTING$. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 4:10:44 PM Error: 2013-06-26 16:10:45.69 …
Venkat
  • 21
  • 1
0
votes
2 answers

SSDT cannot load Package.Dtsx

I have the following environment to develop an SSIS Package : Windows Server 2008 R2, 2 instances of SQL Server 2012 installed (Express and Standard) and SSDT installed. The services of SQL Server Express instance have been stopped. When I start…
JackoBongo
  • 87
  • 3
  • 12
0
votes
3 answers

SQL Server 2012 - SQL Server Data Tools

I have VS2012 Ultimate installed. In the Installed products it states I have SQL Server Data Tools 11.1. When I go to SQL Server 2012 and click on the SQL Server Data Tools Menu option, VS2010 starts up. I changed the target to point to C:\Program…
ErickTreetops
  • 3,189
  • 4
  • 27
  • 37
0
votes
1 answer

SQL Server Management Studio 2012/ALL Tools Install thru Command Line

Ok I managed to find the site, but I'm getting tired and upset so I figured if anyone knew a command line to just install tools thru the command line. SSMS on the server is no longer allowing me to change Maintinance Plans, but it can run them just…
Crazyd
  • 406
  • 2
  • 7
  • 15
0
votes
1 answer

Register custom Transformation in SSIS Toolbox

In VS 2010, how would you register/add a custom transformation to the toolbox?
PositiveGuy
  • 46,620
  • 110
  • 305
  • 471
-1
votes
1 answer

SSIS environments and deployment

I use SQL Server 2012 with Visual studio 2010 with Integration Services Catalog. I would like to know if it is possible to deploy my ssis 2012 project to only one of the three environments I have created. I am trying to understand if this is…
-1
votes
1 answer

SSIS error connecting to Excel Source

I have a 64 bit machine. One of my projects I have the properties of the project for Run64BitRunTime = False and I still get the following error when attaching to an Excel xlsx source in order to import into SQL 2012. Error 1 Validation error.…
ikilledbill
  • 211
  • 1
  • 3
  • 17
-1
votes
2 answers

Difference between SQL Server Management Studio and Express

I try to understand the difference between SQL Server Management Studio and SQL Server Management Studio Express
1 2 3 4 5
6