Category Archives: Uncategorized

Going to the PASS Business Analytics Conference

I found out recently that I’ll be able to attend the PASS Business Analytics Conference this year, which I’m pretty excited about. Also, I’m not presenting at this conference, so I will actually get to relax and enjoy the sessions … Continue reading

Posted in Uncategorized | Comments Off on Going to the PASS Business Analytics Conference

Demo Materials for PASS Session BIA-302 – Building a Supportable ETL Framework

Last week I presented the session “” at the PASS 2013 Summit. Here’s a link to the demo that I went through. BIA-301 – Demo Materials

Posted in Uncategorized | Comments Off on Demo Materials for PASS Session BIA-302 – Building a Supportable ETL Framework

Cannot Create a BI Semantic Model Connection to Tabular Cube

Here’s the scenario: Within the PowerPivot Gallery in SharePoint 2010 you create a new “BI Semantic Model Connection”.  In the “New BI Semantic Model” page you specify the name of the connection, the Workbook URL, and Database.  When you click OK the … Continue reading

Posted in Uncategorized | Comments Off on Cannot Create a BI Semantic Model Connection to Tabular Cube

BISM Connection to Tabular Cube and Data Link Properties

Here’s the scenario: You have a PowerPivot Gallery within SharePoint 2010.  Within the gallery is a BISM connection that points to a Tabular cube.  You attempt to use the BISM connection to open a new Excel workbook by clicking on … Continue reading

Posted in Uncategorized | Comments Off on BISM Connection to Tabular Cube and Data Link Properties

How to Export BLOB data to Files in SSIS

Overview This topic will cover how to export data from BLOB fields in SQL Server and save those files out to the filesystem. This is accomplished within VB.Net code, but could just as easily be ported over to C#. DBServer: … Continue reading

Posted in Uncategorized | Comments Off on How to Export BLOB data to Files in SSIS

Demo Materials for PASS Session BIA-304–Building a Reporting Services Framework

I presented my session on ‘Building a Reporting Services Framework’ at the PASS Summit 2011 on Friday.  I had a great time at the summit, both presenting and attending all the great sessions.  A wonderful time was had by all. … Continue reading

Posted in Uncategorized | Tagged | Comments Off on Demo Materials for PASS Session BIA-304–Building a Reporting Services Framework

Automatically Using the Latest Version of an SSRS Template

The ability to add Templates to SSRS (such as documented here and here and here) is a neat feature.  Basically, you just create an RDL and put it in the “C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDEPrivateAssembliesProjectItemsReportProject” directory… now you can … Continue reading

Posted in Uncategorized | Tagged | Comments Off on Automatically Using the Latest Version of an SSRS Template

Using SSRS queries with parameters with Netezza

Our company has started using SQL Server Reporting Services 2008 R2 to handle most of our reporting against Netezza.  This works pretty well over all using the Netezza 6.0 OLE DB driver.  There are a few things to be aware … Continue reading

Posted in Uncategorized | Comments Off on Using SSRS queries with parameters with Netezza

How to Extract SAP Data in SSIS

This tutorial will step you through installing the Microsoft SAP ADO.Net connector and extracting data from SAP, all via SSIS. But first, some background information. Overview This week brought me the unique challenge of extracting data from SAP within SSIS. … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on How to Extract SAP Data in SSIS

XML as Source in SSIS — Part 2

Now that our data is cleansed, onto loading the data into our table! The cleanest, most sane approach that I have found to parsing through XML within a SSIS script task is by utilizing Linq to XML. More information can … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on XML as Source in SSIS — Part 2