Thursday, January 05, 2006 - Posts

Comparing table data in SQL Server 2005

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Comparing table data in SQL Server 2005
The new RSS feed is here

Have you spent your hard earned money on tools like Redgate's SQL Compare to enable you to compare data. Or just dispaired when your publihser and subscriber get out of sync.

Well in SQL Server 2005 there is a new utility to compare the data in two tables, the data can be in different tables and on different servers.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Comparing table data in SQL Server 2005

posted Thursday, January 05, 2006 6:00 PM by SimonSabin with 0 Comments

SSIS 64 Bit, Excel and Access

If you are lucky enough to have a 64 bit server and are trying to run packages that interface with access or excel you are probably having problems. This has been recently discussed on the MSDN Forums http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=167907&SiteID=1. The reason for the problems is that the Jet engine drivers are 32 bit and not 64 bit. The default 64bit version of dtexec tries to load the 64bit drivers and as there aren't any it fails. You therefore need to use the 32bit version of dtexec, this will try and load the 32 bits drivers.

The 32Bit dtexec can be found in the "program files (x86)" folder.

 

posted Thursday, January 05, 2006 5:53 PM by SimonSabin with 0 Comments