posts - 218, comments - 410, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

February 2007 Blog Posts

SQL Server 2005 SP2 Available

And it is available today.  Microsoft released SQL Server 2005 SP2.

posted @ Monday, February 19, 2007 11:22 AM | Feedback (0) | Filed Under [ SQL Server Stuff ]

SQL Server 2005 SP2 later today?

Rumor has it we're going to see SP2 for SQL Server 2005 later today.

posted @ Monday, February 19, 2007 6:22 AM | Feedback (0) |

Using a Custom Field Delimiter in SSIS Text File Import

Recently I was writing an import in SSIS and needed to use a ASCII 127 as delimiter.  I know you can type a custom delimiter into SSIS but ASCII 127 is the delete character.  Steve Kass reminded me that SSIS' .dtsx files are just giant XML files and easy to edit.  It was as simple as changing this line: <DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">_x007F_</DTS:Property> 007F is the hex code for ASCII 127.  Thanks Steve!

posted @ Sunday, February 04, 2007 12:26 PM | Feedback (0) |

Powered by:
Powered By Subtext Powered By ASP.NET