When you copy a column that has an alias data type from one database to another, the alias data type may not be available in the destination database. In such a case, the column will be assigned the ...

The Copy data from one or more tables or views option may not be available when the wizard uses a [!INCLUDEdnprdnshort] data provider to connect to your data source.This happens when the wizard ...

However, the database is so big that it almost doesn't fit on a CD-R, and we would only like to update a couple tables anyway. I did some googling and found the bcp command.