August 2006 - Posts

Converting delimited, csv, fixed width text to columns in Excel

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Converting delimited, csv, fixed width text to columns in Excel
The new RSS feed is here

If you've ever worked with tables of text data you must have tried to copy data from a file or other place into excel and it all gets dumped in one column. You know its nicely delimited by commas or tabs or may be its fixed width and excel can convert this data into columns when you open a file so why can't excel translate the data into columns when you paste.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Converting delimited, csv, fixed width text to columns in Excel

posted Friday, August 25, 2006 11:25 AM by SimonSabin with 0 Comments

SSIS: Problems with Lookups and comparing data

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS: Problems with Lookups and comparing data
The new RSS feed is here

I'm sure I've seen this mentioned before but as I had forgot about it I thought others might benefit from a reminder.

The Lookup transformation matches data differently when in cached and non-cached (Enable Memory Restriction) mode.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS: Problems with Lookups and comparing data

posted Thursday, August 24, 2006 12:47 PM by SimonSabin with 0 Comments

Data Dude CTP5 is free to download now

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Data Dude CTP5 is free to download now
The new RSS feed is here

I've been quite for a while for a number of reasons, Holiday, baby finally catching up on me and some dreaded DIY.

Anyway I couldn't miss mentioning that CTP5 of Data Dude is now available for download. The great news is that this now supports SQL 2005 although not entirely.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Data Dude CTP5 is free to download now

posted Sunday, August 20, 2006 11:16 PM by SimonSabin with 0 Comments