The sql-server-2012-datatools tag has no wiki summary.
1
vote
1answer
108 views
MS SSAS 2012 - You can only open files that are compatible with Microsoft SQL Server 2012
I am trying to create a new Analysis Services Tabular Project with SQL Server Data Tools in the VS 2010 shell. As soon as I click ok I get the error that the file cannot be opened. Both the client ...
1
vote
1answer
208 views
Logon Fail Integration Services 2012
I have a SSIS Project deployed in SQL Server. The connection manager in the project are linked to a server name that is not the one where the SSIS project is deployed. After i execute the master ...
1
vote
1answer
642 views
Trouble opening a SQL 2005 .dtproj file in VS 2012 or VS 2010 data tools
I tried to open this old SQL Server 2005 code example from a book, but the conversion wizard for both VS 2010 or VS 2012 won't conver this .dtproj, it fails every time and there is really no good ...
0
votes
1answer
8 views
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: ...
0
votes
1answer
117 views
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 ...
0
votes
1answer
826 views
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 ...
0
votes
1answer
230 views
Register custom Transformation in SSIS Toolbox
In VS 2010, how would you register/add a custom transformation to the toolbox?
2
votes
0answers
82 views
+100
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 ...
2
votes
0answers
114 views
Unable to Add Refences in SSIS Script Task
Hello,
I have a particular problem with SQL Server 2012 SSIS. When I want to add a reference "Script Component", in order to use FileSystemObjects. The Visual Studio IDE simply doesn't add it. I'm ...
1
vote
0answers
10 views
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 ...
0
votes
0answers
157 views
SSDT - Reference non-dbo schema
In the case of having 2 database projects in a SSDT solution; DatabaseA and DatabaseB.
DatabaseB has a schema named 'ops' and a table name Person; ops.Person.
In DatbaseA, I would like to build a ...
0
votes
0answers
424 views
sql server 2012 and visual studio 2012 connection
I am trying to connect a database that i created in visual studio 2012 to SQL Server Data Tools 2012 because i want to use the Analytic Tools in SQL server 2012 for making cubes and reporting. But i ...
