Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Bradley Schacht

Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer and tech edited the SQL 2011 Bible. His experience on the Microsoft BI platform includes DTS, SSIS, SSRS, SSAS and migrations and conversions. He has helped numerous companies in successfully developing and implementing new business intelligence solutions into their organizations. Bradley also participates as a speaker in community events like SQL Saturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as BIDN.com and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).

Archives: March 2012

Trim Functions in SSIS

In T-SQL there are many functions there to help do a variety of different things.  SSIS is no different.  In fact, a good number of the commonly used functions from T-SQL are in SSIS as well.  Here we will explore the different Trim functions found in SSIS.

We will be… Read more

0 comments, 621 reads

Posted in Bradley Schacht on 23 March 2012

Excel Source The Output Column Failed Because Truncation Occurred

In an SSIS package you have the option to choose from a wide range of source from Flat Files to writing queries using OLEDB sources such as SQL Server. Often times, such as writing queries against SQL Server, the metadata will come from the table and you won’t need to… Read more

10 comments, 1,883 reads

Posted in Bradley Schacht on 23 March 2012

MDX Functions: BottomCount

The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database.  In the case of examples here, SQL Server Analysis Services. This example uses the Contoso demo cube available for download here: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=18279

Function Name: BottomCount

Use Case: Brings back the lowest… Read more

0 comments, 524 reads

Posted in Bradley Schacht on 12 March 2012

MDX Functions: TopCount

The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database.  In the case of examples here, SQL Server Analysis Services. This example uses the Contoso demo cube available for download here: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=18279

Function Name: TopCount

Use Case: Brings back the highest… Read more

0 comments, 1,041 reads

Posted in Bradley Schacht on 12 March 2012

Date Dimension Script with Fiscal Year

One dimension you can be positive will always make it’s way into your data warehouse is the Date dimension.  Over the past couple of years I have taken a look at a lot of Date dimension scripts and found quite a few good ones.  Well recently I needed to add… Read more

2 comments, 1,578 reads

Posted in Bradley Schacht on 6 March 2012

Introduction to SharePoint BI Webinar Tomorrow

Tomorrow at 11AM Eastern time I will be presenting a FREE webinar for Pragmatic Works (website) on Introduction to SharePoint BI.  Get the details below along with the link to view the FREE event.

Title: Introduction to SharePoint BI

When: Tuesday March 6th, 2012 at 11AM Eastern

Description: Read more

1 comments, 390 reads

Posted in Bradley Schacht on 6 March 2012