Top "Bids" questions

Business Intelligence Development Studio (BIDS) is a special version of Visual Studio that is used to develop projects for SSIS, SSAS, and SSRS.

SSIS Flat File error "Text was truncated or one or more characters had no match in the target code page."

I am working on a SSIS project. I have a Flat File Source (csv) and OLE DB as destination. I …

sql-server ssis etl bids
SSIS Excel to SQL import -- First 6 rows of the file contains header-related information

I am working on importing thousands of rows(120K) of data from an excel file into a SQL Server. Now …

sql sql-server excel ssis bids
SSIS Connection Error

I have the following code written into an SSIS Script Task to connect to my SQL database: ConnectionManager cm; System.…

sql ssis bids
SQL Server 2014: SSISDB vs MSDB for package deployment

I'm currently in the process of upgrading from SQL Server 2008R2 to 2014 (both Enterprise). There are a plethora of SSIS …

sql-server ssis bids sql-server-2014
Access to the Path Error in Visual Studio

This issue was resolved with SQL Server 2008 R2 Cumulative Update 5 / SP1 / SQL Server 2012 RTM On occassion when I try to …

visual-studio sql-server-2008-r2 bids
SSIS Count of Object Variable?

I am using SSIS in BIDS 2008 and I am trying to get a count of an Object Variable containing a …

sql sql-server-2008 ssis bids
SSRS Adding text box that accepts input for printing

Using Business Intelligence Development Studio, I am creating a report for SSRS that requires the user to add a few …

reporting-services ssrs-2008 rdlc bids rdl
SSRS report with 32-bit Oracle Client Not working in 64-Bit Environment

I have a SSRS report using 32Bit Oracle client build in BIDS 2008, Report is running fine in BIDS (VS 2008) but …

reporting-services bids oracleclient badimageformatexception
SSIS Script Component, Allow Null values

I have a SSIS package that I am programming and my script component won't allow null column inputs. I have …

sql-server-2008 ssis null bids
SSRS report losses formatting in Report Manager via Internet Explorer

I have a report that renders a report header on its own page and then two pages for each member …

reporting-services ssrs-2008 bids reportmanager reportbuilder3.0