What could go wrong here?

I created a simple DTS Package to copy one DB from server A to server B
using the Copy Database Wizard. The Package is correctly installed in server
B but when I try to run it I always get this error:

errorCode=-1073548784 description=Executing the query "CREATE VIEW
[dbo].[TableName].... possible failure reasons: Problems with the query,
"ResultSet" property no set correctly, parameters not set correctly, or
connection not established correctly.

I think I did everything right when creating the package... is there any bug
in SQL Server and this Wizard never works, or is just me missing something
here?

Thanks
David