//
archives

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