BI Thoughts and Theories

Last post on presentations for a while, I think / hope. I'll be presenting on Unit Testing in SSIS at the PASS Summit 2008 , occurring in Seattle, WA from Nov. 18-21. There's lots of great content planned at PASS this year, and it's definitely worth attending. Read More...

I'm doing a couple of chalk talks at the Microsoft BI Conference , occurring in Seattle, WA on October 6-8. The chalk talks are a different format than the typical presentation: smaller audience, no (or very few) slides, and more conversational in format. Read More...

There's a SQL Saturday coming up in Greenville, SC on October 11th. It's a free, day long event with a number of great speakers doing sessions. I don't include myself in the great speaker category, but I was asked to present a couple of sessions on SSIS, Read More...

but not very far, just to Nov. 5-7. In order to provide more value to attendees, the BI conference is being run at the same time as the SharePoint, SQL, and .NET conferences. So now, instead of just having access to the BI content, you'll be able to pick Read More...

I'm presenting at the Triad SQL Server User Group tomorrow night on Migrating to Reporting Services 2008. It was a lively group last time I was there, and I'm looking forward to visiting them again. If you are in the area, please stop by. Here's the abstract Read More...

A question that comes up occasionally is how to handle errors that occur on the OLE DB Destination in the data flow. Errors that occur when using the OLE DB Destination to insert into a table are usually caused by primary key, foreign key, or check constraints Read More...