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

Script Editor won't open or change language in SSIS 2005

I have a task which creates a SSIS package using BIDS 2005. There are 2 problems when I work with BIDS 2005, but don't occur in BIDS 2008. Default language in Script Editor is Visual Basic (I prefer C#). When I click on the Design Script button, it…
QuachNguyen
  • 131
  • 11
3
votes
2 answers

SSDT vs SSDT-BI

What are the differences between SSDT and SSDT- Business Intelligence? I've installed SQL Server 2017 and then proceeded to download Business Intelligence Development Studio but found out that it was replaced by SSDT/SSDT-BI (don't know the…
Fayçal Salhi
  • 61
  • 2
  • 9
3
votes
1 answer

SSRS 2008 R2 "Error: Subreport could not be shown"

I have a stand-alone report that works no problem. I have added it as a subreport and linked up all of the parameters, but when I run the report in BIDS I get the error message in the subject of this post. I can deploy the report and I am able to…
Matt Klepeis
  • 1,724
  • 1
  • 14
  • 25
3
votes
1 answer

SSIS Flat File [DT_DBTIMESTAMP] cant convert to SQL datetime2

I created a running SSIS and I tried inserting data without error to SQL Server but suddenly this error message pops up Error: 0xC02020A1 at Data Flow Task, Flat File Source [59]: Data conversion failed. The data conversion for column…
Vian Ojeda Garcia
  • 827
  • 4
  • 17
  • 34
3
votes
2 answers

How to keep both flows using Lookup object in SSIS

Have a problem into a Data flow task, in SSIS. In my current flow, I want to add some additional data, using a lookup object. If there is a match then to add the data based on the settings from the Lookup object and for no match to keep the process…
BogdanM
  • 957
  • 4
  • 15
  • 32
3
votes
2 answers

How to add multiple file extensions to the Files: input field in the Foreach loop container SSIS

How could I add multiple file extensions to the Files: input field in the Foreach loop container in SSIS 2008. I have currently entered as *.zip OR .csv see image... but it doesn not work only works if I have one value like *.zip
milltonion
  • 43
  • 1
  • 9
3
votes
2 answers

SSIS - Data Conversion from DT_STR to int

How to apply the below transformation in SSIS data flow task cast(gift_amount as int)/100 In Derived Column Transformation Editor, I am unable to change the data type. It gives 0xC0049064 error upon giving typecast function.
Tom J Muthirenthi
  • 3,028
  • 7
  • 40
  • 60
3
votes
2 answers

Turning a multi-value parameter into a temp table in SQL Server Business Intelligence Development Studio

I want to create a report in MS SQL Server BIDS (SSMS and Visual Studio). The user would enter a list of email addresses as a parameter. So @pEmails would be 'foo@bluh.com', 'bar@meh.org', etc. These email addresses may or may not be in a table. I…
Dave Lartigue
  • 33
  • 1
  • 5
3
votes
2 answers

Could not load type Error when creating a new Integration Services Package using SQL Server Business Intelligence Development Studio

Could not load type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100' from assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
tinab
3
votes
2 answers

SSIS Data Source Shows String Column as DT_WSTR When it is Single Byte in Oracle Database

I'm developing an SSIS package to extract data from a table in an Oracle 11g database and load it to a table in a SQL Server 2014 database. The table in the Oracle database has string columns defined as VARCHAR2 (single byte / codepage 8859-1); the…
John
  • 1,043
  • 15
  • 20
3
votes
1 answer

SSIS packages 2005 & 2008 editable with what versions of Visual Studio?

I know that in order to edit SSIS packages you need the same version of BIDS or Visual Studio. With Visual Studio 2010 is there any change in the ability to open older SSIS packages or do I need to have VS2005 and VS2008 installed along side my…
John S
  • 7,909
  • 21
  • 77
  • 145
3
votes
1 answer

SSRS BIDS How to change "Deploy" account credentials

I'm using BIDS (Visual Studio 2008) to create and deploy SSRS reports to a report server, on a third-party hosted server. The username and password that it uses to deploy reports onto the report server seems to be saved somehow, and I don't seem to…
Matt
  • 61
  • 1
  • 8
3
votes
0 answers

SSRS: Run stored procedure or sql script when report loads

Maybe rookie question but: Is there a posibility to force a SSRS report to run a specific sproc or script in the data source before loadin any data source / data set cache etc ...? In order to guarantee that no matter in which order the datasets…
Dvintila
  • 212
  • 3
  • 13
3
votes
2 answers

Using version control with SSIS packages (saving 'sensitive' data)

We are a team working on a bunch of SSIS packages, which we share using version control (SVN). We have three ways of saving sensitive data in these packages : not storing them at all storing them with a user key storing them with a…
sandesh247
  • 1,658
  • 1
  • 18
  • 24
3
votes
1 answer

Uninstall BIDS 2008

I had successfully installed BIDS 2008 on my machine. I uninstalled it, and now need to re-install it. When going through the setup, Business Intelligence Development Studio has gray check mark in the Feature Selection screen. Visual Studio…
Josh F
  • 31
  • 3
1 2 3
…
49 50