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

SSIS - Calculate Opening and Closing Balance

I need to calculate the Opening Balance and the Closing Balance in SSIS. I have the below data as input. invoice_date amount 12/4/2016 4000 12/5/2016 5000 12/6/2016 7500 12/7/2016 5000 12/8/2016 8000 I want the…
Yousuf Sultan
  • 3,055
  • 8
  • 35
  • 63
2
votes
1 answer

Which approach is better for saving the error in SSIS

I use SSIS for transferring the data and I use SQL server 2016 I need to use some lookup component in my DataFlow task and if I can't find the matches, I should save the record as information in one table. That means if for each Lookup component I…
Ardalan Shahgholi
  • 11,967
  • 21
  • 108
  • 144
2
votes
3 answers

SSRS reports rendering differently in the ReportViewer than in Visual Studio

My SSRS rdl report is rendering differently in the ReportViewer in an ASP.NET application than it does in BIDS (for this project we are on SQL Server 2008 R2 and BIDS). It renders the way I want it in BIDS, but the Report Viewer changes the…
awright
  • 1,224
  • 1
  • 13
  • 23
2
votes
1 answer

SSIS: How can I manipulate data from one table in a dataflow and then put it into another table?

For instance, I have DB A and DB Bb, I would like to set up a data flow task where I take the first ten rows from Table A and programmatically put them in XML format in a string builder. Then, once I have it in the stringbuilder, put the entire…
Matthew
  • 23
  • 3
2
votes
2 answers

What is the difference between SSIS packages and SQL Server Data Tools (this replaced BIDS)

We have some large Excel files (often in excess of 100MB each) that need to be regularly brought in to a SQL Server database and I am looking for options to automate this process. It sounds like Microsoft is no longer supporting its Businesss…
user7050575
  • 51
  • 1
  • 8
2
votes
1 answer

Informix - BETWEEN two dates

My query is something like... SELECT * FROM table WHERE datetime BETWEEN two_sundays_ago AND last_sunday I've looked through the date/time functions from IBM (link) plus some other documentation but I'm struggling to understand how to do two…
esafresa
  • 480
  • 7
  • 19
2
votes
0 answers

Error Executing SSIS Web Service task

I am trying to execute SSIS Web service task and i get the following error when I execute it: [Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: …
vanpra1
  • 21
  • 3
2
votes
1 answer

How can I prevent BIDS from automatically checking out SSIS packages?

I have Visual Studio 2005 (BIDS) set to "Check out automatically" when a file is edited which works well for most file types. When I access a Data Flow within an SSIS package though, a check out is triggered without me making any changes. When I…
Scott Munro
  • 13,369
  • 3
  • 74
  • 80
2
votes
1 answer

SSIS 2014 integrate SAP BW, MS Connector 1.1

I'm trying to setup the integration between SQL Server 2014 and SAP BW 7.3. I read a white paper but it was talking about SQL 2008 and MS Connector 1.0. I'm using SSIS 2014 on VS 2012 with MS Connector 1.1 librfc32.dll is in system 32 folder. When…
Ml Ck
  • 37
  • 7
2
votes
1 answer

Bug in the SSIS BIDS File System Task Editor?

Add a parameter to your package. Scope is not important. Set the Sensitive property to True. Add a new File System Task to your package. Double click to open the editor. Set IsDestinationPathVariable = True Attempt to set the property…
BIDeveloper
  • 2,628
  • 4
  • 36
  • 51
2
votes
1 answer

How can I set the folder description during deployment with Visual Studio?

We use SQL Server 2012 Enterprise and have a lot of Reports using the SQL Server Reporting Services (SSRS). We use Visual Studio 2012 / 2013 for deploying the Reports to different Servers. We have a solution file with different project. Each…
Joel
  • 4,862
  • 7
  • 46
  • 71
2
votes
3 answers

How can I specify a Stored Procedure to be used in the SSRS Report Wizard?

In a BIDS project, after selecting Reports > Add New Report, and adding a connection string as the Shared Data Source in the Report Wizard, the wizard next prompts for a query (in the "Design the Query" page of the wizard). I want to specify an…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
2
votes
1 answer

XML Schema Query - maxOccurs?

…
HendrixAndChill
  • 91
  • 1
  • 2
  • 9
2
votes
1 answer

SSRS/BIDS - How to add text/label to a pointer?

I'm trying to add a label or text to a pointer in a Gauge. I've searched on the web but I'm unable to find out how to display the numerical value associated with the pointer. Any help would be appreciated. Thanks! Note: I referred to this post but I…
RizJa
  • 1,961
  • 1
  • 21
  • 38
2
votes
1 answer

SSIS - How to execute next Task after For Loop

Im trying to execute a SQL Task after a For Loop Container completes (i.e performs its iterations) but it just wont execute. I cant for the life of me work out why it wont execute as there are no errors. Any ideas? The Loop executes the correct…
Matt
  • 389
  • 1
  • 8
  • 15
1 2 3
…
49 50