Stack Overflow
Stack Overflow

Questions tagged [ssdt-bi]

96 questions
1
vote
0 answers

SSIS package working in SSDT and not working in SQL server after I deploy it

I have an SSIS package that creates a next day folder based on the previous day folder in a directory, when i run the package directly from SSDT it generates the folder,however when i deploy the package to Sql server intergration catalogue and…
Tshepiso Selepe
  • 67
  • 1
  • 9
1
vote
1 answer

How can I copy an SSAS cube from one project to another?

I have two Analysis Services projects. I want to copy a cube from project A to project B. How can I copy an SSAS cube from one project to another?
Tarzan
  • 4,270
  • 8
  • 50
  • 70
1
vote
1 answer

SSIS 2017 - Package Parts - "P"s disappear, no longer configurable

I am using the new Control Flow Package Parts for my project, and they are hit-and-miss. Sometimes I can drag them on to my packages fine, and they work as expected; however, I have experienced the following problems, and I would like to know if…
codeMonkey
  • 4,134
  • 2
  • 31
  • 50
1
vote
1 answer

How can I upgrade SSIS project dtproj files from 2008 to 2017

After installing SSDT for SQL Server 2017 in VS 2017, I still cannot load an earlier version's dtproj file. This project is incompatibility with the current edition of Visual Studio The old .dtproj looks like this:
BozoJoe
  • 6,117
  • 4
  • 44
  • 66
1
vote
1 answer

Visual Studio Analysis Services Extension not deploying tabular Measures

I have a fairly simple tabular sales model (Customers, Products, Sales) deployed to a SSAS 2016 server in tabular mode and I have a few measures setup on the sales table, things like total value, total kgs, total units, but after deploying the…
Nathan Fisher
  • 7,961
  • 3
  • 47
  • 68
1
vote
1 answer

Install arguments breaking an automated PowerShell install

I'm installing SQL Data Tools via a PowerShell script. I run my script, but the final part where the Data Tools are installed fails (inside of the SQL installer window). If I run the script without that part, and install Data Tools manually it…
jdope
  • 115
  • 2
  • 14
1
vote
1 answer

Code SSRS report to format -1 to Yes

I have a SQL query that is displaying "-1" when a selection is made (this is done through an external script writing to the table) I'm wondering if anyone can help me with some code to apply to the SSRS report to auto format this to "Yes"? Thanks in…
Welldonebacon
  • 83
  • 1
  • 8
1
vote
1 answer

DTSX and SQL Server 2014

I am a freelancer. At a client's place, SQL Server is 2014, but the only DTSX tool is BIDS 9, which I would like to remove to install something a bit more up-to-date. I am a bit confused by some pages telling that SSDT is for VS 2012 or 2013, and…
iDevlop
  • 24,841
  • 11
  • 90
  • 149
1
vote
1 answer

using ssdt, how can I create a filtered index on the latest 7 days?

We use SSDT to deploy our database changes. We have a script that recreates the index every week. Our script looks like this: declare @cmd varchar(max) set @cmd = ' CREATE NONCLUSTERED INDEX [iAudit-ModifiedDateTime] ON…
Ron Osmo
  • 11
  • 2
1
vote
1 answer

How do I uninstall SSDTBI for VS 2013/SQL Server 2014?

I recently installed the client tools for SQL Server 2016. This seemed to hose the COM classes for SSIS in my VS 2013 install, as well as my SSMS 2014 install. I get a COM class not found {guid} error. I don't have a screenshot because I have since…
IronicMuffin
  • 4,182
  • 12
  • 47
  • 90
1
vote
1 answer

SSIS Package Connection Manager does not recognize my Teradata drivers

I have Visual Studio 2010, 2012, 2013 installed. I also have the VS2015 SSDT Preview installed. I'm editing some existing SSIS Packages that have Teradata as a source. The properties are set in the connection manager. I have the following Teradata…
Quicksilver
  • 295
  • 4
  • 16
1
vote
2 answers

Visual Studio 2015 SSDT-BI Designer Font Size

Something has changed in VS2015 in the past week which has caused all of my SSDT-BI design files to appear with a high level of zoom and increased font size. Everything else in VS is fine. I've tried everything in the font and other options that I…
Ian Lee
  • 370
  • 1
  • 3
  • 15
1
vote
0 answers

SQL Server 2012 Agent SSIS Job Succeeds with Project Config to Environment Broken

This sounds similar to SSIS package SQL job not using new environment variable configuration, but when I did a test on my dev SQL Server box, I didn't have to restart the SQL Server agent. And honestly, if that is what it takes to prevent someone…
katzbatz
  • 332
  • 2
  • 16
1
vote
1 answer

SSRS in VS - buggy clearing rsRuntimeErrorInExpression Expression warnings

When editing Expressions in VS2013 shell for SSDT (all patched), if a Warning is generated and then resolved (eg a conversion issue is then fixed in Design or RDL XML), VS keeps displaying it even though Preview/Run/Build is fine: Warning 1 …
TickboxPhil
  • 151
  • 2
  • 10
1
vote
0 answers

Error trying to install SSDT-BI on Windows 10 / SQL server 2014 / Visual Studio 2013

I have recently installed SQL Server 2014 (Developer Edition) on my Windows 10 Pro machine x64. I already had Visual Studio 2013 (Community Edition) installed and have successfully added SQL Server Data Tools (SSDT) to that. I have however just hit…
ChromaticRanger
  • 140
  • 3
  • 16
1 2 3
4
5 6 7