sql server dts: Hi

I am trying to use transfer database task to move/copy some database from A server(sql 2000 server) to B server (sql 2000 name instance which has SQL 7 as default instance).

But, the task failed with "unspecified error" message. I couldn't find more information other than "unspecified error".

Does anyone know this issue? Thank you

Allan,

Thank you for your quick response. After that, I use backup/restore and detach/attach database to move the database.

I still would like to find out the problem. Would setup the logging and find the issue. Thanks.

Set up logging for the package in the package properties. This may give you
more of a clue.

Personally though if I was moving whole DBs I would be using BACKUP and
RESTORE.
This way if the RESTORE fails at least I have the BACKUP to work with.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]
A server(sql 2000 server) to B server (sql 2000 name instance which has SQL
7 as default instance).
[quoted text, click to view]

i can't promise anything from the logging but it is as good a step as you
are going to get. You could also try running Profiler at the same time to
see statements isuued and any errors.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]