Stack Overflow
Stack Overflow

Questions tagged [ssdt-bi]

96 questions
0
votes
1 answer

Iterate directories in SQL Server 2012/2014

We have been using a custom component for iterating directories in SQL Server 2008 R2. Now, we are planning to upgrade to SQL Server 2014, but it looks like SQL Server 2014 does not support custom components from 2008 R2 (not quite sure what's going…
Data enthusiast
  • 11
0
votes
1 answer

SSIS File System Task after SQL task

I have one Execute SQL Task (DOE Params) with script: select SystemCode ,[Group] ,Process ,InputFolder ,InputFileName ,TargetFileName from rpt.v_cfg_Report_DOE_Parameters where Report_Id = ? and Procedure_Id = ? And…
Darko Milic
  • 189
  • 3
  • 13
0
votes
0 answers

SQL Server Management Studio 2014 stops working after installing SSDT-BI for visual studio 2013

Initially I had installed SQL Server 2014. Then I installed SSDT-BI for visual studio 2013 from here I have installed SSDT-BI using a new SQL instance when prompted. Also in my machine it is not installed MS Visual Studio 2013. After installation…
Willy
  • 9,848
  • 22
  • 141
  • 284
0
votes
0 answers

Add empty rows to tablix dynamically in SSRS

I would like to ask around for help. How do we add empty rows to tablix dynamically in SSRS, as in I wrap the rows(including the totals) inside the list. And I want to have fixed table layout in every page mostly just like this: But, It has multiple…
LittleBirdy
  • 479
  • 2
  • 6
  • 22
0
votes
0 answers

Analysis services target server

I am using Visual Studio Community 2015 with SSDT installed, my database is held in SQL Server 2014. When I start a new analysis project and include my DB from SQL Server, everything seems to be fine, but when I click mining model viewer the message…
Andrew Stepanenko
  • 1
0
votes
1 answer

Run SSIS/SSDT on app server

My company is insisting that we not run SSIS/SSDT jobs on the DB server, but instead run them on an app server and since they're not offering any assistance how this possible I'm trying come up with ways to do it. Here are my ideas so far, but…
CraigW
  • 3
  • 1
0
votes
1 answer

Visual Studio SSDT BI 2015 for VS 2013 - SSIS only opens Advanced Editors

Not sure what happened here. I had some issues with versions of SSDT-BI. In any case, the last one I installed was SSDT-BI for Visual Studio 2013. Now when I open my integration services projects. If I click on, for example, an ole db source, it…
IronicMuffin
  • 4,182
  • 12
  • 47
  • 90
0
votes
1 answer

No BI Templates after installing SQL Server Data Tools for Visual Studio 2015

I had Visual Studio 2015 Update 1 installed then I installed SQL Server Data Tools (SSDT) for Visual Studio 2015. When I open VS 2015 I do not see any of the Business Intelligence Templates that would let me create SSIS and SSRS projects. I…
John81
  • 3,726
  • 6
  • 38
  • 58
0
votes
1 answer

Avoid restarting each time a dtsx package locks in VS 2013

This is driving me crazy. I'm using SSDT-BI for Visual Studio 2013 and have to restart my machine each time a dtsx package is locked. There is a good post on how to get around this for SSIS 2012 , but can't find anything on how to fix the problem…
Benjamin Button
  • 13
  • 5
0
votes
0 answers

SSDT-BI 2013 slows to a crawl when loading a Data Flow component from an SSIS Pkg

New to using SSDT-BI 2013. I have loaded up an SSIS package with a complex Data Flow component. When I double click the data flow component to open it up it takes over a half hour to validate everything. No errors, just a very long time to load,…
A.G.
  • 2,089
  • 3
  • 30
  • 52
0
votes
1 answer

Establish Oracle OLEDB connection in SSAS

Trying to establish an Oracle data source in SSAS using the data source wizard. I have the connection information in the traditional TNS format: CMAN1= (CONFIGURATION= (ADDRESS=(PROTOCOL=tcp)(HOST=proxysvr)(PORT=1521)) (RULE_LIST= …
Pablo Boswell
  • 805
  • 3
  • 13
  • 30
0
votes
1 answer

How to create a relationship in an SSDT model based on multiple columns?

I am creating a model for Sqlserver Analysis Services (tabular mode) using SSDT. My core measures are in a table with a combined key on UserId and WeekId. I have relations to other tables on UserId and on WeekId. Now I want to add another relation,…
Teun D
  • 5,045
  • 1
  • 34
  • 44
0
votes
2 answers

SSDT BI Custom connection manager AccessViolationException

I've created a custom connection manager for SSDT BI (SSIS) which will connect to an Oracle database using Oracle's managed data access library (Oracle.ManagedDataAccess.dll). On my development machine, this connection manager, and the custom "data…
nitedmn
  • 94
  • 10
0
votes
1 answer

SSDT BI Custom Connection Manager

I'm attempting to create a custom connection manager for use in SSDT BI jobs but I'm having an issue getting the custom connection manager to show up as an option. I'm using Visual Studio 2013 with the SSDT BI plugin (or whatever they call it) for…
nitedmn
  • 94
  • 10
0
votes
1 answer

Unable to open VS2012 BI project after having to recreate Windows profile

I had to recreate my Windows user profile due to some technical problem that kept me from logging in. Now I'm trying to recover all my software, etc. I start VS2012 and opened the project I'm currently working on which is an SSDT/SSDT-BI project -…
Richard Schaefer
  • 525
  • 3
  • 13
  • 45
1 2 3 4 5
6
7