There is one other 32-bit/64-bit difference regarding SSIS.  If you have any scripts in your SSIS packages, the need to be precompiled before they are deployed on the 64-bit server. ...

Naming the data warehouse with the name of the OLTP system may not be the best.  As a conultant would say, "It depends."  A data warehouse cuts across all organizational...

Depending on your server utilization, you could crate a Data Warehouse database on the same server as your OLTP database, but I would advise againast it.  I would get a...

Oh, you could try downloading Toad for SQL Server and see how that works.

I agree.  I had to wait for SP 2 to be released to load the SQL Server 2005 client tools on my Vista laptop, but I use it a lot...

Oh, and a few years ago I would have done it with nested cursors.  learned some tricks at a couple of interviews that have paid off nicely!

We are building a data warehouse.  Part of it includes what I will call an ODS (operational data store) even if it doesn't really fit that definition.  It will be...

I have loaded and patched the SQL Server 2005 client tools, and they work fine.  If you need to and can, install a virtual pc and load XP as the...

I don't have any documents to show you, all I can tell you is what we do.  Where I work now, our servers are rebooted weekly.  At my previous employer,...

I found a problem, my cut and paste was incomplete.  Here is the full code:

set nocount on

declare @SQLCmd varchar(max),

        @schemaid int,

        @objectid int,

        @loopcnt int,

        @DestinationDB sysname,

        @SourceDB sysname

set @DestinationDB...

If the database was setup with the wrong collation, a backup and restore won't fix that.

Try this code (I would comment out the exec statements first and see what the output of the print statements are first):

use DWODS /* probably want to set this to...

I could put together a script that will build your insert into commands and run them dynamically if you would like.  I have built several scripts that dynamically build some...

How many tables in the database?

See post above yours.....  I just Editted it.