PRB: You Must Select the Include All Dependent Objects Checkbox that Depend on Other Objects in DTS (281664)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q281664

SYMPTOMS

In Microsoft SQL Server 7.0, when you use Data Transformation Services to transfer objects that depend upon other objects in the database, often it is enough to just list all the objects by using the Select Objects button. In SQL Server 2000, the transfer script may not create the objects in the correct order and may fail with an error message that is similar to:
Microsoft SQL-DMO (ODBC SQLState: 42S02)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name '<object name>'.

CAUSE

SQL Server attempts to create an object, OBJ1, that depends on another object, OBJ2, before that object, OBJ2, has been created and fails.

WORKAROUND

To work around this problem, select the Include all dependent objects checkbox.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbprb KB281664
©2003 Microsoft Corporation. All rights reserved.