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
5
votes
2 answers

How can I access user roles/permissions with SSRS and BIDS Custom Security Extension?

I have written and deployed a custom security extension for SSRS 2008r2 and it works beautifully apart from when trying to deploy reports from within BIDS 2008/Visual Studio. The architecture for the security extension handles logins via multiple…
Dan
  • 1,489
  • 12
  • 16
5
votes
1 answer

SSIS Writing 0x00 Hex Value to Flat File

I am using SSIS to write multiple packed fields (hex values) to a flat file for a mainframe system. I have found that writing 0x00 or NULL doesn't write NULL it writes 0x20 or a space. Is there a way to write a NULL character to a flat file with…
buzzzzjay
  • 1,140
  • 6
  • 27
  • 54
5
votes
0 answers

SSIS OLEDB source error - Opening a rowset for SQL Server View failed

We have an SSIS package where we have used SQL server view as a data source by selecting data access mode as Table or view. The package has been scheduled to run daily using SQL Server Job. Most of the time the job gets executed without any issue,…
Sandeep T
  • 421
  • 8
  • 22
5
votes
4 answers

How do I programmatically deploy BIDS artifacts to remote SQL Server instance?

I would like to automate the deployment of my SSIS and SSAS artifacts to remote development SQL Server 2005 & 2008 instances on a scheduled basis. What would be the best solution for this? I am using TFS 2008 as the source control system, so I'd…
Mr. Kraus
  • 7,885
  • 5
  • 28
  • 33
5
votes
1 answer

SSAS sum measure based on daily currency exchange rates

This measure, successfully converts my measure to the currency selected. So if I get data, from the 1st of the month, till the 15th of the month, what will happen is that the exchange rate taken for the currency selected would be of the 15th of the…
Mez
  • 4,666
  • 4
  • 29
  • 57
5
votes
3 answers

SSIS Script Component, Allow Null values

I have a SSIS package that I am programming and my script component won't allow null column inputs. I have checked the box to keep nulls in the flat file source component. My program is running well until my script component where I get the error…
user2471943
  • 81
  • 1
  • 2
  • 5
5
votes
1 answer

SSIS DataFlowTask DefaultBufferSize and DefaultBufferMaxRows

I have a task which pulls records from Oracle db to our SQL using dataflow task. This package runs everyday around 45 mins. This package will refresh about 15 tables. except one, others are incremental update. so almost every task runs 2 to 10 mins.…
Maximus
  • 792
  • 9
  • 19
5
votes
1 answer

SSRS Tablix Insert Row Keyboard Shortcut

I have several SSRS reports to create for a client that need to have a table layout. I know that some people frown on using the Tablix only for this purpose, but trying to align rectangles and other controls is extremely time consuming. Many of…
GibsonCode
  • 89
  • 2
  • 13
5
votes
1 answer

Assign keyboard shortcut to context menu items in report designer

I'm currently creating some reports in BIDS (SQL Server 2008 R2, VS2008). I feel that I constantly need to access the dialogs Expression... and Textbox properties... in the designer but it slows me down to use the mouse and context menu all the…
adrianm
  • 14,468
  • 5
  • 55
  • 102
4
votes
1 answer

SSRS BIDS expression Show/Hide image based on passed through parameter

Is it possible to have an image available if a certain field is selected, in this case the parameter is @employeename, I only want the image that has been placed on the report to display if a certain value is true. What is the syntax, field i am…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
4
votes
1 answer

Is it wise to disable a Task by using an expression evaluation?

I have an SSIS Package that is scheduled to export data on a daily basis. I have a few Tasks that I'd like to execute only on the first day of the month. It is important that these Tasks are skipped, and that the Package continue to execute if it…
RLH
  • 15,230
  • 22
  • 98
  • 182
4
votes
0 answers

Integration Services 2019 - Execute Process Task - WindowStyle ignored

I recently migrated projects developed in Sql Server BIDS 2008 to Visual Studio Professional 2019 with SSIS extension. After the upgrade all the packages are now up and running, but when I run them in debug mode, all Exectue Process tasks with…
AdamL
  • 12,421
  • 5
  • 50
  • 74
4
votes
2 answers

SSIS : Creating a flat file with different row formats

I want to create a flat file output, where format of rows is different. file has header, middle data rows, footer row. file will look Like below H|deptcode123|deptNameXYZ|totalemp300 E|Sam|Johnson|address1|empCode1|........many other…
coder
  • 122
  • 1
  • 13
4
votes
2 answers

SSRS 2016 Adding Columns or Unmerging Cells gives "Undocumented/RDL structure invalid" Error

Recently, I've been going through and converting/recreating a number of SSRS reports for the new 2016 version. For the main part things are going well and the reports end up looking better, but I've run into one pretty glaring issue. And that's an…
bitnine
  • 1,752
  • 1
  • 17
  • 20
4
votes
2 answers

SSRS/BIDS 2008 Unable to load the credentials. Type is not in the serialization whitelist

I am unable to run a report from bids when connecting to ANY (local, and remote) server. The local report runner comes up with the following error: An error occured during local report processing. Unable to load the credentials. Type…
jlnorsworthy
  • 3,914
  • 28
  • 34
1 2 3
…
49 50