MS SQL Server DTS - A problem with DTSTransferObjectsTask

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

A problem with DTSTransferObjectsTask

Robert Glaser

2005-09-23, 7:23 am

Hi,

I use " DTSTransferObjectsTa
sk" to copy an attached database file. Everything
works fine.

But if the package wants to copy a view with the content
"CREATE VIEW dbo.Archive AS SELECT
& #91;W2K_PROF_PCS7_TL
G_S_200509220929].dbo.Archive.* FROM
& #91;W2K_PROF_PCS7_TL
G_S_200509220929].dbo.Archive"
I get the error:
"Invalid object name 'W2K_PROF_PCS7_TLG_S
_200509220929.dbo.Archive'"
The error is correct because the database W2K_PROF_PCS7_TLG_S_
200509220929
is not attached.

Is there any way to perform a successful transfer of the whole database ?
(may be without syntax check)
The backup function inside the Microsoft SQL Enterprise Manager copies the
whole database with the view and with no errors.

Many thanks in advance.

Robert Glaser.

Sponsored Links