Business Intelligence

• Topics

  Started by

  Posts

  Last post

• SSIS - how to watch the values in SSIS variables in debug mode

  I am using an Execute SQL task to run an SP that return a state abbreviate but I can't find out if …

  adam spencer

  3 replies

  3 years, 7 months ago

  By: gowthamrajbm

• cannot find MSOLEDBSQL driver for SSIS 2019 connection manager

  In the list of connection manager driver, I cannot  find MSOLEDBSQL, There is a microsoft OLEDB fo…

  sqlfriend

  4 replies

  4 years, 1 month ago

  By: sqlfriend

• The 'Database storage location' feature is not included in the '64 Bit Standard Edition' SKU

  All, I'm working a short-term contract for a client that has SQL Server 2008 running on Windows Ser…

  Mike Austin-398977

  5 replies

  4 years, 3 months ago

  By: amiroolbahri

• Job fails with error : Failed to add row to output buffer SSIS

  I have a data flow task with 2 components : source ODBC : with more than 3 000 000 rows OLEDB Desti…

  ahmed_tn

  1 replies

  4 years, 3 months ago

  By: Thom A

• SQL Server Agent - SSIS Package Fail as the connection cannot be seen by the Agent

  Hi All I am really struggling to find the source of this issue. I am using SQL Server 2012 with Vis…

  tlally

  30 replies

  4 years, 6 months ago

  By: leandro

• SSIS Data Flow documentation

  Does anyone know if there is a tool or utility to extract metadata on the Data Flows from SQL 2005 …

  Holly Kilpatrick

  1 replies

  4 years, 7 months ago

  By: barnadnl

• Print the selected database from datasource on reporting services report

  Hello, We have 3 environments over here (Development, Test, Production), When we create reports we …

  Van Heghe Eddy

  20 replies

  4 years, 10 months ago

  By: Ram

• INFO: LoadSnapshot: Item with session: zbifro55f3pbokb0sj5ichjh, reportPath: , userName: abc\rptsrv not found in the database

  Hi, We have SQL Server 2005 reporting services. Reporting services is configured with all default s…

  Mani-584606

  4 replies

  5 years ago

  By: sqlfriend

• Power Pivot Deployment

  Hi all, I am SQL Server DBA. I am investigating different BI options for an organisation. Today I j…

  Blue Mancunian

  9 replies

  5 years, 6 months ago

  By: Blue Mancunian

• 2005 Reporting Services - Multiple Worksheet data starts on second row in Excel.

  Hi guys, I am running SQL Server 2005 Reporting Services sp 2. When I create any 2 tables on a repo…

  Corey

  5 replies

  5 years, 7 months ago

  By: gurmeetxsingh

• MSBI Beginner pls guide me

  hello all, Am a .net developer, i want to learn new technology,an i am in confusion whether i want …

  ghousal.azam

  7 replies

  5 years, 8 months ago

  By: DataMinax

• RowIndexOutOfRangeException

  Microsoft.SqlServer.Dts.Pipeline.RowIndexOutOfRangeException: PipelineBuffer has encountered an inv…

  sarvanjonty

  2 replies

  5 years, 9 months ago

  By: meetsudhakarrao

• How to update SSAS 2008 dimension without redeploying whole cube?

  Hi all, I have made some changes to the hierarchies in a single dimension within a SSAS 2008 projec…

  lorenzdominic_

  5 replies

  5 years, 11 months ago

  By: SQL Server Youngling

• SQLDUMPER_ERRORLOG.log

  Hi everybody, i'm getting one dump file when i run SSIS package. Any idea about how SQLDUMPER_ERROR…

  Rajesh.KB

  8 replies

  5 years, 11 months ago

  By: gstockfisch

• Generic Percent of grand total MDX expression

  Hello everyone, I have this problem to find a generic MDX expression that returns the percent of gr…

  mrani.soukaina

  1 replies

  6 years ago

  By: hlo11