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

SQL Server BIDS OLE DB inputs

I have a a script component and an OLE DB destination. My script has 3 columns to return. How do I map each of these 3 columns to the OLE DB destination? Whenever I drag a connector from the script component to the OLE DB, it makes me select…
CodeKingPlusPlus
  • 15,383
  • 51
  • 135
  • 216
0
votes
1 answer

SQL Server BIDS data manipulation

I have an Excel Source and an OLE database destination. For the column mappings I need to first perform some data manipulations on the columns. How do I get a substring from one of the source columns to be mapped to one of the destination…
CodeKingPlusPlus
  • 15,383
  • 51
  • 135
  • 216
0
votes
1 answer

In SSIS 2008 BIDS write execution log to file

I execute a BIDS package using command line (.bat). The package has a script task that successfully writes out a variable to the execution results when executed within BIDS: ([The Process is ] Information: VariableName) I log this process when I…
jabs
  • 1,694
  • 4
  • 19
  • 36
0
votes
2 answers

SQL Server BIDS primary key column

In BIDS I have an excel source and an OLE Database destination. However, in my OLE database I have a primary key id field which is not mapped to from my excel source. How do I create values to be inserted to my primary key id field? I have never…
CodeKingPlusPlus
  • 15,383
  • 51
  • 135
  • 216
0
votes
1 answer

SQL Server BIDS maximum error count

I am working in SQL Server BIDS and I keep receiving the error: Error Code: 0x80019002 BIDS tells me I have reached the maximum amount of errors, but it never tells me what the errors are... How do I find out what the errors are? So far all my…
CodeKingPlusPlus
  • 15,383
  • 51
  • 135
  • 216
0
votes
1 answer

Visual Studio 2008 and Business Intelligence Development Studio

I installed the SQL Server 2008 R2 and now I have the Visual Studio installed with the Business Intelligence tools (which I need). But now I need the other Visual Studio tools, like C++, C#, etc... Before I have to use the BIDS tools I used to…
nmartins
  • 185
  • 2
  • 10
0
votes
1 answer

Create list of individual items that make up a grouped total

wizards, experts, simple workingmen like me and all other well-meaning people I might have forgotten: I have a problem and need your help...... I have a report 'TRAINERMEETING' in which I count the number of people (people_ID) that have attended a…
Henrov
  • 1,610
  • 1
  • 24
  • 52
0
votes
1 answer

SSRS Bids default zoom on report

When I open my report, the default zoom is 100%, for the purpose of my report, the user needs to look at 75% and I am worried that every time they run the report they will have to manually adjust this. I can imagine that could get quite tedious. Is…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
0
votes
1 answer

How to dynamically set connection string at SSIS?

I have a SSIS-project which uses xml-configuration file (dtsConfig) where the connection string to source data base is given. Configuration file is stored to environmental variable. Data needs to pulled from four different data bases, i.e. now I…
Juha S
  • 25
  • 1
  • 7
0
votes
3 answers

SSIS Custom Component works in VS2008 but fails under DTExec, possibly related to LineageID

I am writing a custom SSIS component that works fine when run from within Visual Studio; however, it fails when run using dtexec.exe or dtexecui.exe. The failure occurs in the PreExecute method when I am building up a mapping from column names to…
Ukko
  • 2,236
  • 2
  • 21
  • 33
0
votes
1 answer

Dimension attribute with duplicate values allowed in SSAS 2008, gets error in 2005

I have a cube in SQL Server Analysis services 2008 that contains a time dimension comprised of years and quarters. There is a separate YearQuarterID column as well. The Quarter attribute (type Quarters) consists of integer values 1 - 4 for each…
Buggieboy
  • 4,636
  • 4
  • 55
  • 79
0
votes
2 answers

Can I run/test/create dtsx packages outside Visual Studio?

Not too familiar with dtsx packages - can they be created/run outisde Visual Studio? Is BIDS (Business Intelligence Development Studio) just required to do all the above (in Visual Studio) or is it an independent development enviroment for dtsx…
JohnIdol
  • 48,899
  • 61
  • 158
  • 242
-1
votes
6 answers

Handling non existent values in sql query expression for ssrs chart

I am using the following query in an ssrs line chart. It counts how many orders are recorded each month based on each order date. My problem is that when a month has no orders, rather than saying zero or null it removes the row for that month all…
NebDaMin
  • 638
  • 2
  • 10
  • 32
-1
votes
1 answer

Any reason why a try catch exception would report a file path wrongly in SSIS?

So I have this SSIS package that has a script task that is copying files to a destination and then putting their data into C# data structures to parse later. However, it runs through the first file and then suddenly I get this exception from a try…
Justin Le
  • 673
  • 1
  • 8
  • 24
-1
votes
3 answers

SSIS 2008 R2 - Can I set a variable to the name of the current scope?

This seems ridiculously easy, but I can't find it anywhere... I have a VERY simple sequence container with two tasks: Truncate a SQL table, and repopulate it from production. But this container will be repeated for about 50 tables. The container's…
user1916006
  • 31
  • 1
  • 4
1 2 3
…
49 50