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
0
votes
1 answer

SSRS cannot deploy

I am an db admin on the server. I have granted the user with "SYSTEM user" on site setting, "Content Manager" on the Home folder, and also "Content Manager" on the her folder XXX. However, she cannot deploys her report on BIDS and get this error…
Ahmad Danial
  • 79
  • 2
  • 8
0
votes
1 answer

Importing multiple Flat Files into Single OLE DB Table destination(all files have different columns for table)

I am currently working on creating an SSIS package for a new import files we will received. The company changed how it was before - 1 flat file for 1 table. Now they have there data scatted across multiple files for 1 table. I have 2 data flow tasks…
Brody
  • 1
  • 4
0
votes
1 answer

unable to log execution of package BIDS 2012 (SSIS)

I have installed SSIS for VS2012 (SQL Server 2012) and I am able to create basic packages that run, however I am unable to get any of the logging to work. I have configured logging for text files and for the SQL Provider however, neither will log…
kwcolson98
  • 77
  • 1
  • 7
0
votes
1 answer

How do I write an expression to pull the next row value

I have a report in SSRS that I want to create an expression on the row header to pull the next date value from a dataset. ="Week of " + First(Fields!FiscalDate.Value, "ds_FD") Something similar to this, but it needs to go through the next value and…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
1 answer

How to pass a specific Parameter value to Jump to report in SSRS

I have a report I created in Reporting Services using BIDS. I have multiple text boxes that I have a Jump to assigned to go to the same report. However, I want to be able to pass a specific parameter value to the query of the Jump to report to…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
2 answers

Split up a column if certain parameters are present

I am at a loss of what to do as I am able to fully read in a column with a Flat File Source, but if certain things are avaiable, I need to split those into a separate column. Example: line 1) 2013-08-23 14:03:17 ipaddress:port @client POST /api…
Nick
  • 662
  • 2
  • 7
  • 21
0
votes
0 answers

How to pass multiple values to a single parameter in a Reporting Services report

I have a report in Reporting Services with a text box field in a table that has a Go to report Action. I need a Parameter for specific values to be able to pass to that report. The IN (@Parameter) will not work with multiple values. I have two…
tsqln00b
  • 355
  • 1
  • 4
  • 20
0
votes
1 answer

SQL command to find when a document was last printed?

I have a table of document names and dates when they were printed. Say: aaa 2006-09-15 aaa 2007-09-15 abc 2013-08-12 abc 2012-08-12 After the command executes I need: aaa 2007-09-15 abc 2013-08-12 I got something close to a correct…
Toadfish
  • 87
  • 1
  • 1
  • 5
0
votes
1 answer

Microsoft BIDS How to clear table data before new transfer?

I have a database from which I am pulling rows from, manipulating the data a bit and then putting into another table. Every time I run the package, it doesnt remove any data from the destination and thus grows by X number of rows each time. Is there…
Toadfish
  • 87
  • 1
  • 1
  • 5
0
votes
2 answers

Pass SSRS parameter to SQL query

I've built an SSRS report that is supposed to look at data from one of several tables with similar names - i.e., table001, table010, table011, etc. When I was building the report, I was only including three of the tables, out of more than a dozen.…
Ben C.
  • 1,761
  • 5
  • 15
  • 24
0
votes
2 answers

Unique values for drop-down menu

I've got an SSRS report with several different drop-down parameter menus, each of which depends on the selections in the menus before them. The report is taking similar data from several different tables, so there is some repeated data, and these…
Ben C.
  • 1,761
  • 5
  • 15
  • 24
0
votes
0 answers

Get specific recordset value using MAX

I have the following condition: =MAX(Fields!CodeCount.Value, "Query1") & " " & First(Fields!CodeVal.Value, "Query1") Which yields 3 ABC Now I need to find the MAX and three is the correct answer but I don't need it beyond evaluating so what I want…
GPGVM
  • 5,515
  • 10
  • 56
  • 97
0
votes
0 answers

Improve / simplify / convoluted IIF statement

I have a moderately complex report and toward the bottom I have some summary / calculations being done on the above data. One such calculation simply adds various fields across the report. For example: TextBx1 + Txtbx2 + Txtbx3 etc. Now this might…
GPGVM
  • 5,515
  • 10
  • 56
  • 97
0
votes
1 answer

Multiple appearances of a name in a SharePoint list, but need only one for BIDS report

I'm building a report in BIDS based on a SharePoint list. I want to make a multi-valued parameter to filter the list by a name, but each name shows up multiple times in the list. The report is already going to be filtered by work site, and I need…
Ben C.
  • 1,761
  • 5
  • 15
  • 24
0
votes
0 answers

SSRS 2008 with VS 2012 Error ORA-12638

I have the system below: Windows 7 64Bits Visual Studio 2012 with Business Intelligence Template Oracle XE 11g Win 32bit Oracle SQL Developer 3.2.20 ODTwithODAC1120320_32bit for .Net I tried to access Oracle localhost DataBase from SQL Developer…
Olivertech
  • 567
  • 2
  • 4
  • 24
1 2 3
…
49 50