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

SSAS - Changing Target Server

I am new to analysis services and data cubes. I inherited someone else's project, and I am using BIDS 2005. The company I work for recently relocated my analysis database to another server--lets say from "Server1\tst1" to "Server2\tst1". Now…
David Benham
  • 1,164
  • 11
  • 17
2
votes
1 answer

Deploying from BIDS to SSRS - Parameters Not Getting Updated

I'm noticing some strange behaviors when deploying reports from BIDS to SSRS. I have a parameter that has default values, but those default values don't seem to be getting propagated to the Report Server (they are stored in Parameters field in the…
ek_ny
  • 10,153
  • 6
  • 47
  • 60
2
votes
6 answers

Adding optional filter in SSRS 2008

I am trying to add an optional filter on a text field in a report. I have tried setting it up in the dataset but it treats it as a required filter so if it is not populated, no results are returned. It needs to use the Like operator. Any advice?
sukach
  • 271
  • 1
  • 3
  • 14
2
votes
2 answers

SSRS 2008 partial string formatting

Say I have a data field (call it Results.MyString) that looks like this in a text box in my report: Some text here for all to read. Also, say that I have a data field (call it Results.MyParam) that has this value: here Is there a way to…
Vaccano
  • 78,325
  • 149
  • 468
  • 850
2
votes
1 answer

Why does child SSIS package's .dtsx file get opened in BIDS when running parent package in debug mode?

SSIS 2008 R2 + BIDS I'm in the process of rewriting an ETL job. The job is composed of about 50 steps, some of which are SSIS packages, and some of which are just stored proc calls. I'm writing a wrapper proc (Gatekeeper) that checks which of these…
digital.aaron
  • 5,435
  • 2
  • 24
  • 43
2
votes
0 answers

SSIS compiles in BIDS, fails in DTEXEC

I have a SSIS package, it runs fine in visual studio with BIDS, where it is developed (except for running out of memory due to 32-bit limitation). Now, when I re-build the package, copy the dtsx to another location and ask DTEXEC to run it, I will…
Rasmus4J
  • 23
  • 8
2
votes
1 answer

Package Source Path not populated while using DtExecUI.exe

I had SQL Server 2008 installed earlier. I had the ability to right click on any SSIS package and select Open With "SQL Server 2008 Integration Services Package Execution Utility" as an option to run the package standalone. Recently, we upgraded…
Sam
  • 392
  • 1
  • 6
  • 18
2
votes
1 answer

Mismatch on SQL_variant and DT_WSTR in BIDS Manager

I'm using BIDS to update some data to SQL Server 2008 R2. My source is a varchar and destination table has this column VariantValue as a sql_variant datatype. So I have used a derived column transformation to create a unicode new column with this…
Nade
  • 23
  • 4
2
votes
1 answer

How to write format expression for 100k separator in SSRS?

I have searched on google and nothing found about lac (Indian numbering system) separator in SSRS report and I am familiar with thousand separators, I am using visual studio 2012. for ex: input 1111500000, output like this: 11115,00,000. I need 1000…
sudhakar
  • 53
  • 10
2
votes
2 answers

SSIS: ODBC Connection Issue in BIDS 2008

I have an oracle DB i need to talk to so i installed the drivers and added it to the system DSN Data Sources. IM ON SQL SERVER 2008 R2 64bit In BIDS, I can see the name of the DataSource, however when i go to enter it in the connection manager I…
Kevin
  • 39
  • 1
  • 1
  • 5
2
votes
1 answer

SSIS and SSDT 2015

I am developing a SSIS 2008 R2 package in Visual Studio 2015 using SQL Server Data Tools and i am getting the error listed below. Is these two truly not compatible or is there a setting I can change (or workaround)?
Steve Salowitz
  • 1,283
  • 1
  • 14
  • 28
2
votes
1 answer

SSIS: is it possible to remove a specific character in a string then transform it to integer

I am wondering if you can handle a string data 337-4425 and remove a specific character like - and change it to a integer data type. I am curious if this is possible. You can share your thoughts about it, I'll appreciate it and like to learn from an…
Vian Ojeda Garcia
  • 827
  • 4
  • 17
  • 34
2
votes
2 answers

SSIS - Merge Join Issue when Inputting to Multiple Destinations

One Destination - All Merge Join Rows Two Destinations - Fewer Merge Join Rows Can anyone please explain this behavior for me? I am generating a count field and then feeding that to back into the main stream with the merge join and then performing…
Topher McData
  • 41
  • 5
2
votes
1 answer

Cannot debug a script task

I exported a package from the production server (.ispac) to my local computer and opened in SQL Server Data Tools 2015 since I need to make some changes in the work flow. This package also include a script task which I need to alter and debug. I…
user2307236
  • 665
  • 4
  • 19
  • 44
2
votes
1 answer

SSIS Flat file destination export multi-line column

I have a SQL table as Source and I want to export it's contents to a Flat file using SSIS. Simplified example: Source: Notes table (CreatedBy, Description, CreatedOn) The Description field is nText. Destination: Flat file - Fixed length…
Amanvir Mundra
  • 420
  • 1
  • 6
  • 20
1 2 3
…
49 50