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

Why SSDT BI installation needs SQL Server installation?

Why SSDT BI installation needs SQL Server installation as we are ultimately going to deploy BI packages on server where SQL Server would already be available? I need it for SSRS.
Vikas
  • 31
  • 4
-1
votes
2 answers

How to use SSIS Visual Studio 2008 to build Dynamic Datapull from multiple SQL servers for multiple tables using foreach loop

What I want to do is build a dynamic data pull from different SQL source servers (Server1,Server2,Server3) etc. To pull down to dynamic locations on my SQL server (Dev,Prod) into databases (database1,database2,etc) The tables will be dropped and…
Ryan David Hocking
  • 117
  • 1
  • 8
-1
votes
2 answers

How to display condition based values out of SQL query result?

I have a simple query that returns a table. One of the columns gives a long string of characters with some repeatable text string which I want to remove prior rendering the table result content. There will be a clear indication which characters…
Mario
  • 9
  • 3
-1
votes
2 answers

Using ANY free SQL Server version to simply create a local SSIS/dtsx file run on local machine

Yes I KNOW there are a lot of questions about this on styack overflow, and I'm sorry but all I found was reading through dozens and dozens where every one seemed to disagree, or things were terribly version specific and more importantly - many of…
Isaac
  • 351
  • 1
  • 4
  • 21
-1
votes
2 answers

Sql server reporting service not showing report data

I created a report project in sql server business intelligence developement studio and deployed successfully with sql reporting service url(Webservice url).It work fine but when i browsing my report application through reporting service url and…
user110104
  • 1
  • 3
-1
votes
1 answer

Large file, SSIS to Small chunks, parallel enrichment

I have a pretty large file 10GB in Size need to load the records into the DB, I want to have two additional columns LoadId which is a constant (this indicates the files unique Load number) ChunkNumber which would indicate the Chunk of the batch…
bhushanvinay
  • 449
  • 1
  • 5
  • 21
-1
votes
3 answers

Match [DimTime] table with fact table?

I'm a BI beginner, so please bear with me. I have a fact table [Fact15MinData] that looks like this: Cell Date Hour Minute Counter1 Counter2 Cell1_1 20141001 2 15 2.4 4.5 Cell1_1 20141001 2 30 4.5 …
Joe_Hendricks
  • 746
  • 4
  • 16
-1
votes
1 answer

STRING DATE TO INTEGER DATA IN SSIS DERIVED COLUMN?

I am exporting a flat file into a database that has year column (int data type). Flat file has string date(yyyy). Is there a way to do so using derived column in ssis or anywhere in ssis?
apariyar
  • 35
  • 2
  • 11
-1
votes
2 answers

how to use BIDS to show SSRS report from Window form

Hello friends I want to display SSRS report in my local Window form. IN report viewer i don't want to display it from URL. I want to show reports without deplyoing it. Can anyone give me idea for that?
Jigar Parekh
  • 595
  • 10
  • 23
-1
votes
2 answers

Which version of SQL Server client does BIDS come free?

I am struggling to find the right version of the software to download to get BIDS for free with SQL Server client. I tried installing SQL server 2008 R2 edition . I was able to see BIDS . But, when i launch it , ia m getting error as follows: To…
Sai Avinash
  • 4,683
  • 17
  • 58
  • 96
-1
votes
1 answer

BIDS issue converting date string

I'm trying to fire off an RDL via KRONOS application. The problem I'm running into is passing the variables in the same format. I have a query that is selecting a date field that is formatted (DateTime,NULL). It looks like the variables are being…
gfuller40
  • 1,183
  • 9
  • 19
  • 36
-1
votes
2 answers

SSIS - get filename of a file in SFTP directory?

Is there a way to access an SFTP directory using BIDS? I need to check if a file exists in it. I have read everywhere and can't find anything that would solve my issue. This is for a package that uploads files using a batch file and checks which…
user1993177
  • 573
  • 2
  • 6
  • 9
-2
votes
1 answer

MDX Code much slower than MDX Browser

When I browse my Cube and drag/drop different elements for calculations I get my results within a second or two. However, my MDX code (created by the Wizard) takes around 6 minutes or so.. let's say I have 10 instances of what I drag/drop for…
LearnByReading
  • 1,813
  • 4
  • 21
  • 43
-2
votes
1 answer

Error in FROM clause: near '{'. Unable to parse query text

I'm trying to execute the following query for a Dataset: SELECT S.CUSIP, S.SecName, ISNULL(RA.FinInstCode, '') AS RemarketingAgent, S.IssueDate, S.MaturityDate, F2.FinInstName AS Trustee, CASE WHEN SC1.ExpirationDate IS NULL THEN ''…
kingblazi
  • 23
  • 1
  • 6
-3
votes
1 answer

How to install BIDS in a server

Install BIDS Hi, anyone can help to install business intelligence development studio in a server. Thank you
user2839765
  • 31
  • 5
1 2 3
…
49
50