Hi,
I use DTS to transfer database from one server to another.
1. I created empty database on destination server (to make
desired disk layout)
2. I created DTS package (Data Import) which imports
everything, data and objects from source server.

This package was failing because of strange error:

[SQL Server]Database 'Orders' cannot be opened due to
inaccessible files or insufficient memory or disk space.

Database 'Orders' exists only on source server. I
generated sql script for the database i wanted to transfer
on source server, and it doesn't contain ANY reference
to 'Orders' database!!!
Later I created blank 'Orders' database on destination
server, and dts package passed objects transfer!!!

Unfortunatelly, I got another surprise:
Only objects were transfered, not data! I checked
option "Copy Data" in package definition.

Does anybody have an idea what's going on here?
OJ