Category Archives: Syndication

AS400 Program from SSIS

Posted on June 3, 2013 by MikeDavisSQL

If you need to call an AS 400 program from an SSIS package this can easily be accomplished with an Execute SQL Task. This can be made even easier with two variables and an expression too. The AS400 program QCMDEXC … Continue reading →

Posted in SSIS, Syndication | Tagged , | Leave a comment

Bulk Insert Task SSIS – Path Specified Cannot be Found or File Does Not Exist

Posted on May 27, 2013 by MikeDavisSQL

When using the Bulk insert task in SSIS, you might encounter an error stating that The File Does Not Exist or The Path Specified Cannot be Found. This is usually due to the fact that the file must be on … Continue reading →

Posted in SSIS, Syndication | Tagged | Leave a comment

Per Member Per Month Per 1000 Calculations in MDX

Posted on May 20, 2013 by MikeDavisSQL

In a lot of industries there is a popular calculation called “Per Member Per Month Per 1000” calculation or the “Per Customer Per Month Per 1000” calculation. This is used to determine the level at which the company is rendering … Continue reading →

Posted in mdx, SSAS, Syndication | Tagged , | 4 Comments

SSRS Map Label Overlap Fixed

Posted on April 10, 2013 by MikeDavisSQL

In Reporting Services 2008 r2 and above there is a great tool called the Map tool. It is great for visualizing data across a map. One of the issues I have run into is overlapping labels. For example I am … Continue reading →

Posted in Syndication, Uncategorized | Leave a comment

Studying and Learning Business Intelligence

Posted on October 2, 2012 by MikeDavisSQL

I have been doing interviews for Pragmatic works for the past few years and I have come across quite a few people who wanted to be hired as a senior BI consultant and their skills were just not up to … Continue reading →

Posted in Business Intelligence, PASS, Pragmatic Works, SSAS, SSIS, SSRS, Syndication, Training | Tagged , , | 2 Comments

Crystal Reports DataDate in SSRS

Posted on July 16, 2012 by MikeDavisSQL

Crystal Reports has a special field name “DataDate”. This date shows the last time the data on the report has been executed. A recent client asked for the similar functionality in SSRS when a snapshot is run. They wanted to … Continue reading →

Posted in SSRS, Syndication | Tagged | Leave a comment

Using PowerPivot to Monitor Reporting Services

Posted on June 12, 2012 by MikeDavisSQL

PowerPivot is a powerful new tool from Microsoft that has been improved even more in the 2012 release, which you can download for free here. In this blog I will give you a PowerPivot workbook that I created to connect … Continue reading →

Posted in powerpivot, Syndication | Tagged , , | 2 Comments

Oracle Date issues with PowerPivot

Posted on May 29, 2012 by MikeDavisSQL

This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the below error when trying to import: OLE DB or ODBC error: Accessor is not a parameter accessor.. Out of line … Continue reading →

Posted in powerpivot, Syndication | Tagged , | Leave a comment

SSIS 2012 Copy or Duplicate Environments

Posted on May 2, 2012 by MikeDavisSQL

In SSIS 2012 there is a great new feature called environments. They can be thought of as a collection of parameters or variables. One of the questions I get asked when teaching SSIS 2012 is “Can I duplicate an environment?”. There … Continue reading →

Posted in SSIS, Syndication | Tagged , | 10 Comments

How to use Report Builder 3.0

Posted on April 16, 2012 by MikeDavisSQL

I did a webinar during the 12 days of 2012 on how to use Report Builder 3.0. In this webinar I showed how to pull data from Stored Procedures and Shared Data sets. I also showed the issues that come … Continue reading →

Posted in SSRS, Syndication | Tagged | Leave a comment