Archive for

SQL Server 2008 SP1

Microsoft has now released SQL Server 2008 SP1. So if you are running SQL Server 2008 you should considering installing the latest service pack. … Be sure and test it out in Dev first 🙂

Text was truncated or one or more characters had no match in the target code page.

I recently had an unusual problem with one of my SSIS packages after modifying the destination table layout from VARCHAR to NVARCHAR. The package included a data flow task that ran in-line SQL as an OLE DB Source. I was using a case statement to reformat the backupset. type column. Of course after changing the … Continue reading