Monthly Archives: May 2010

Moving SSIS Packages with ADO.NET Destinations Between 2008 R2 and 2008

As noted by Matt Masson from the Integration Services team, not much has changed in SSIS 2008 R2. In fact, R2 is pretty much identical, with the exception of the ADO.NET Destination. So if you are developing packages, you can … Continue reading

Posted in Uncategorized | Comments Off on Moving SSIS Packages with ADO.NET Destinations Between 2008 R2 and 2008

How to Save Yourself From Yourself

Have you ever wished there was some sort of magic “undo” button for something that you just did? Maybe you didn’t really mean to delete all 10 million records out of your table. You just forgot a little thing called … Continue reading

Posted in Uncategorized | Tagged | Comments Off on How to Save Yourself From Yourself

Inconsistent Column Width in SSRS

The issue I ran into was this: I was in Design mode of a report that I was developing. No matter what I did to change the column width on my columns, in both Preview as well as when I … Continue reading

Posted in Uncategorized | Comments Off on Inconsistent Column Width in SSRS

Speaking at the Carolina Code Camp

I’ll be presenting a couple of sessions at the Carolina Code Camp on Saturday, May 15th. This will be my second time presenting at the Carolina Code Camp, and I’m looking forward to it. Last time, I had great audience … Continue reading

Posted in Uncategorized | Comments Off on Speaking at the Carolina Code Camp

T-SQL Tuesday #006 – LOBs in the SSIS Dataflow

The topic for T-SQL Tuesday #006 is LOB data, selected by this month’s host, Michael Coles. If you aren’t familiar with T-SQL Tuesdays, Michael has a nice summary in his post. In database terms, LOBs are Large OBjects, also referred … Continue reading

Posted in Uncategorized | Comments Off on T-SQL Tuesday #006 – LOBs in the SSIS Dataflow