Azure. Business Intelligence. SQL Server. Nerd Stuff.
Business Intelligence / SharePoint / Speaking
by Bradley Schacht · Published March 5, 2012 · Last modified October 13, 2015
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...
by Bradley Schacht · Published December 16, 2011 · Last modified October 13, 2015
If you have used SSIS to move data from something like Access or more commonly Excel, it is a good possibility you have seen this error at some point: Error: The ‘Microsoft.Ace.OLEDB.12.0‘ provider is not registered on the local machine....
by Bradley Schacht · Published September 29, 2011 · Last modified October 13, 2015
Over the last week I have done several sessions either for the Pragmatic Works Free Training online or at SQL Saturday. It has been a lot of fun, so thank you to everyone who has come out and hopefully learned...
Business Intelligence / Speaking
by Bradley Schacht · Published September 21, 2011 · Last modified October 13, 2015
Thank you to everyone who attended my free webinar hosted by Pragmatic Works yesterday (September 20, 2011) on SSIS Variables and Expressions. The webinar was recorded, so if you want to reference it again or if you were unable to...
Business Intelligence / Speaking
by Bradley Schacht · Published September 20, 2011 · Last modified October 13, 2015
Looks like it is that time again… for me to present a FREE webinar for good ol’ Pragmatic Works today at 11AM eastern standard time. The topic today will be SSIS variables and expressions. I previously did a webinar on...
Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance. It is very possible to over configure a package, so be sure that you only do what you need to in order to make...
Business Intelligence / Speaking
by Bradley Schacht · Published June 9, 2011 · Last modified October 13, 2015
I want to say a huge thank you to everyone who attended the webinar from Pragmatic Works (website) that I did on Tuesday. If you missed it the topic was Dynamic SSIS: Configurations, Expressions and Variables. I got a lot...
Business Intelligence / Speaking
by Bradley Schacht · Published June 7, 2011 · Last modified October 13, 2015
If you were able to make it out to SQL Saturday in Pensacola this past weekend I want to say a big thank you! We had a great time at a very successful event. I was able to help out...
by Bradley Schacht · Published April 24, 2011 · Last modified October 13, 2015
Checkpoints in SSIS are a great tool and they definitely have their place. The downside to them is that they are not so good when you start talking about parallel processes or containers. What follows is a little bit of...
by Bradley Schacht · Published October 19, 2010 · Last modified October 13, 2015
There is an issue with script tasks in SSIS 2005 that could come up occasionally. It is generally an issue that shows up in a 64-bit environment where the script can’t be pre-compiled. The error that will show up states that “The...
