|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
|
Backup/Restore | |
|
Connectivity | |
|
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
 |
Trouble | |
|
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 Why DTS Import Wizard fails when importing table with a timestamp column? Answer: This is SQL Server 7.0 DTS Import Wizard bug. The SQL Server 7.0 DTS fails when you use the "Copy table(s) from the source database" option of the SQL Server 7.0 DTS Import Wizard to import table with a timestamp column. To work around the DTS fails problem, you can use the "Use a query to specify the data to transfer" option of the DTS Import Wizard and exclude the timestamp column; you can use "Transfer objects and data between SQL Server 7.0 databases" option of the DTS Import Wizard and specify which table you want to transfer; you can define the destination table to use binary(8) for the datatype for the column which will contain the timestamp. See also this link about DTS fails and troubleshooting DTS problems: How to troubleshoot DTS problems |