Category Archives: Database and BI

SQL Server 2012 Tabular Models vs. PowerPivot

Posted on January 15, 2012 by Jennifer Salvo

I recently installed SQL Server 2012 and began exploring the tabular models.  At first glance, they look very similar to PowerPivot and contain much of the same functionality.  In fact, both the tabular model and PowerPivot share the same engine … Continue reading →

Posted in Database and BI, Technology | Tagged , , | 1 Comment

SSIS: Using the Script Component to Obtain an Error Description

Posted on December 27, 2011 by Jennifer Salvo

In the SSIS data flow, many data flow components provide an ErrorOutput that allows you to route rows that generate errors or truncation to another component in the data flow.  The ErrorOutput path contains the following metadata: ErrorCode, ErrorColumn and … Continue reading →

Posted in Database and BI, Technology | Tagged | Leave a comment

SSIS: Handling Truncation and Data Errors

Posted on December 27, 2011 by Jennifer Salvo

SSIS provides functionality to handle unexpected data in the data flow.  Data flow errors are often due to invalid data values (e.g. string instead of number) and data truncation.  Many components in the data flow support error outputs that allow … Continue reading →

Posted in Database and BI, Technology | Tagged | Leave a comment

SSRS: Checking for Divide By Zero Using Custom Code

Posted on November 25, 2011 by Jennifer Salvo

I encountered a divide-by-zero error while working on an SSRS report and thought the issue could easily be resolved using IIF with code similar to the following: =IIF(Fields!Denominator.Value = 0, 0, Fields!Numerator.Value/Fields!Denominator.Value) I soon realized that this does not resolve … Continue reading →

Posted in Database and BI, Technology | Tagged | Leave a comment

SSIS: Implementing IsNumeric( ) Logic Using the Data Flow Script Component

Posted on November 25, 2011 by Jennifer Salvo

SSIS does not include an ‘out-of-the-box’ isNumeric( ) function.  Fortunately, this functionality can be implemented using the script component in the data flow. I am going to make the assumption that readers are familiar with the SSIS script component.  If … Continue reading →

Posted in Database and BI, Technology | Tagged | Leave a comment