Stack Overflow
Stack Overflow

Questions tagged [bids]

Business Intelligence Development Studio (BIDS) is a special version of Visual Studio that is used to develop projects for SSIS, SSAS, and SSRS.

The Business Intelligence Development Studio (BIDS) is a tool that Microsoft has released to create projects surrounding the Microsoft SQL Server tools. These tools include the Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Analysis Services (SSAS) and Microsoft SQL Server Reporting Services (SSRS). Developers use the Visual Studio development platform to create these projects. Each SQL Server tool comes with an installation of Visual Studio (BIDS). You cannot get BIDS without having at least a developer copy of one of the Microsoft SQL Server tools.

For more about BIDS and its role in developing projects for SQL Server tools, go here:

http://msdn.microsoft.com/en-us/library/ms173767.aspx

736 questions
13
votes
3 answers

How to execute a Process Task where the Executable path comes from a user Variable

I have an SSIS package that includes a Process Task. The process task needs to execute batch file. The location of the batch file varies depending on the environment (dev, production). How do I dynamically set tghe value of the Executable property…
Chad
  • 23,658
  • 51
  • 191
  • 321
13
votes
2 answers

Where is the msdb database for standalone SSIS Servers

I am working on a DWH application. The server I was granted access to only has SSIS installed with no database engine. I am getting errors like: The EXECUTE permission was denied on the object 'sp_ssis_listfolders', database 'msdb', schema…
Moslem Ben Dhaou
  • 6,897
  • 8
  • 62
  • 93
13
votes
2 answers

SSIS Expressions setting two variables

I'm trying to use an "Expression Task" within SSIS to simply initialize/set two variables. This seemingly simple task has driven me nuts because I don't know how to separate the statements: @[User::testVariable]="1" @[User::testVar2]=3 That…
LearnByReading
  • 1,813
  • 4
  • 21
  • 43
13
votes
2 answers

SSRS 2012 right aligned text cut off

We recently upgraded from SSRS 2008 R2 to SSRS 2012. A good portion of our existing reports are now rendering with some columns cutting off right-aligned text. We used BIDS 2008 to develop the reports and then deploy the RDL's to SSRS 2012…
drizzie
  • 3,351
  • 2
  • 27
  • 32
13
votes
3 answers

There was an exception running the extensions specified in the config file. Maximum request length exceeded

I have a report part which deployed perfectly every time I made any changes until today. The report has around 20 links, and an image on it. I have added a table to it today, clicked deploy and it gave me the following error: Error 1 There was…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
12
votes
3 answers

SSRS - Expression using different dataset fields

I have a report with multiple data-sets. Different fields from different data-sets are used in different locations of the report. In one part of the report, I need to do a calculation using fields from two different data-sets. Is this possible…
Zolt
  • 2,761
  • 8
  • 43
  • 60
11
votes
4 answers

BIDS for Visual Studio 2015

Does anyone know if/when the BIDS add-on will be available for VS2015? It's the only thing holding us back from migrating. Or is there different method for building SSRS reports in VS2015? Update: Our code solutions typically consist of multiple…
djm61
  • 464
  • 1
  • 8
  • 23
11
votes
4 answers

Trying to process the cube but getting the error at impersonation information

I have built a cube in Business Development Intelligent Studio(BIDS) using some database with the name 'Test_cube' which consists of Products dimension table, customers dimension table and orders fact table. The products table attributes…
Manu'sa Bora
  • 131
  • 1
  • 1
  • 13
11
votes
4 answers

How to get BIDS for Visual Studio 2008 SP1?

I currently use Visual Studio 2008 SP1 and have been migrating older projects into VS2008 but existing SSIS and SSRS (2005) projects have not been compatible with VS2008. It has been a pain to maintain those BIDS projects as a separate solution. I…
BlackMael
  • 3,198
  • 5
  • 25
  • 42
11
votes
6 answers

SSIS: Just started getting a "Key not valid for use in specified state." error on my scheduled SSIS package

I have 2 scheduled jobs on my SQL Server 2005 machine that are scheduled to run each morning (around 2:00 AM). These jobs have worked fine (mostly) for years and although I've had a few hiccups that I've had to work through this problem is…
RLH
  • 15,230
  • 22
  • 98
  • 182
10
votes
6 answers

SSIS: How to disable task?

I would like to keep a task in an SSIS package but enable/disable it when i please. Is there a way to do this? Is this big business?
kev
  • 101
  • 1
  • 1
  • 3
10
votes
1 answer

SQL Server 2014: SSISDB vs MSDB for package deployment

I'm currently in the process of upgrading from SQL Server 2008R2 to 2014 (both Enterprise). There are a plethora of SSIS jobs that are in production, and which will need to be migrated. I'm trying to get a handle on how I should manage SSIS jobs…
Skkra
  • 121
  • 1
  • 1
  • 5
9
votes
3 answers

TF31002 error in Visual Studio 2008 Business Intelligence Development Studio

I'm trying to get my SQL 2008 client tools talking to TFS 2010. The address http://tfs-server:8080/tfs works fine in VS2010, but both SSMS (SQL Server Management Studio 2008) and BIDS (Business Intelligence Development Studio 2008) both give me this…
harvest316
  • 1,401
  • 14
  • 21
8
votes
1 answer

SSRS BIDS 2008 Solution Explorer sub folders as in report manager

See screen shot. Is it possible to do any sort of organising in the solution explorer view for a large project. For example in my report manager view I am able to put all Dashboards and related reports into a folder to help organise but it seems…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
8
votes
2 answers

SQL Server 2005: Select One Column If Another Column Is Null or Contains a Word

I am trying to create a report using BIDS. I want one of the columns to provide an email address. I have two tables containing email addresses. One contains the original email address the customer provided when they started doing business with us.…
ThaKidd KG5ORD
  • 1,535
  • 3
  • 24
  • 38
1
2
3
…
49 50