Questions tagged [ssdt-bi]
96 questions
67
votes
3 answers
64 bit Microsoft SQL Server Data Tools
I am having trouble finding the 64 bit version of Microsoft SQL Server Data Tools.
Does any one know where i can download the 64 bit version of Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 and SQL Server 2014.
I…
StackTrace
- 9,190
- 36
- 114
- 202
36
votes
3 answers
SSDT-BI SSIS in x64?
I run Visual Studio 2012 and I'm new to SSIS. I attempted to install SSDT-BI (June 2013 version) in order to research SSIS, but I was unable to complete the install with my default instance because the architectures don't match--my server is x64…
bwerks
- 8,651
- 14
- 68
- 100
27
votes
5 answers
SSDT for visual studio 2015
Does this exist? I can't find SSDT for visual studio 2015? anyone know if this exists or is/when it is going to be available?
must be a way of developing in SSIS/RS in Visual studio 2015?
EDIT
Found this, http://blogs.msdn.com/b/ssdt/ probably the…
JQuery
- 889
- 3
- 13
- 35
20
votes
2 answers
Can I control the version of new SSDT reports in Visual Studio?
I am using the Visual Studio SSDT BI add-on to create reports for SQL Server Reporting Services. The project I've created is configured to target SQL Server versions 2008/2012/2014, since those are the target SQL Servers our customers have.
However,…
Michael Edenfield
- 28,070
- 4
- 86
- 117
12
votes
2 answers
Anyway to deploy a SSIS 2012 project built in VS 2013?
First, I'm loving the very clearly delineated versioning of the SSIS tools. >:(
I installed SSDT BI for Visual Studio 2013 and built a nice little project in it to generate test data. Within VS 2013, I ran this thing hundreds of times. I can deploy…
Greg McGuffey
- 3,116
- 3
- 38
- 58
9
votes
1 answer
SSRS Backup files being created in VS 2017
Multiple - Backup.rdl files are being created in the project folder which is giving me a huge headache with Source Control with SSDT in VS 2017. Has anyone figured out how to stop these being created ?
SQLApostle
- 570
- 3
- 15
8
votes
7 answers
SSDT 2017 Setup Failed The configuration registry key could not be opened
We have been using VS 2017 Shell version for BI development for a few months without problems but today it stopped unexpectedly and restarted on its own. After the restart, we got an error:
Could not load file or assembly
…
Sandra
- 175
- 1
- 2
- 11
7
votes
0 answers
Setting TargetServerVersion property for an SSIS project to 2014 globally in VS2015
When creating a new SSIS project in VS2015 the default TargetServerVersion is set to SQL Server 2016 by default. I would like to set this to SQL Server 2014 as (a global) default.
Also when I need to have a quick look at the package and simply…
dim
- 136
- 1
- 12
7
votes
2 answers
To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher
I am testing SSIS package that I upgraded from VS2005 project to VS2013 (package deployment model) project. This is very simple package which just processes files one by one from specific location and updates database based on those files and once…
JackLock
- 1,168
- 1
- 13
- 26
7
votes
3 answers
Why is SSDT Schema Compare showing difference in DefaultExpressionScript?
While comparing Database instance to a Database project in VS2010 using SSDT, it shows a difference in one of the Stored Procedures. The Store Procedure DDL script is exactly the same but when I expanded the Properties folder under the Store…
Ross Brigoli
- 676
- 1
- 12
- 22
7
votes
1 answer
Cannot use a sensitive project parameter on SSIS 2012
In SSIS 2012 I am trying to use a sensitive project parameter for an OLEDB connection for oracle.
It works perfectly with the Sensitive property set to FALSE (in Project Params Designer). But I do not want the password to be visible like that.
As…
Vick
- 71
- 1
- 2
7
votes
2 answers
SSIS - How to make script component fail task?
I have a Script component (Script Transformation), which I need to be able to fail the DFT, i.e. the Data Flow Task that it is part of.
I am firing an error like this
try
{
// Does some work here, which can fail...
}
catch (Exception ex)
{
…
Anders
- 894
- 2
- 10
- 25
6
votes
2 answers
How to upgrade SSRS 2005 report project for use with modern SSRS versions?
I have installed SQL Server Data Tools for Business Intelligence (SSDT-BI) version 14.0.61705.170 and SQL Server Reporting Services (SSRS) version 14.0.608.142.
I'm trying to upgrade and edit a collection of older report files for use with the…
Hydrargyrum
- 3,378
- 4
- 27
- 41
6
votes
1 answer
Visual Studio 2013 High DPI workaround causes debugger to fail
Similar to this question Visual Studio 2013 High DPI on 4k Screen to which I had posted an answer but have now removed since uncovering the issue below.
I too have just bought a new 4K laptop and have been having problems with high DPI with the…
Liesel
- 2,929
- 2
- 12
- 18
5
votes
3 answers
Report preview cannot find Data source folder
When I try to preview report in Visual Studio 2012 Designer I am getting an error:
An error occurred during local report processing.
An unexpected error occurred in Report Processing.
An error occurred during local report processing.
Error in the…
user170442