Article ID: 281664 - Last Review: October 17, 2003 - Revision: 3.2

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

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q281664
Expand all | Collapse all

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>'.
Back to the top

CAUSE

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

WORKAROUND

To work around this problem, select the Include all dependent objects checkbox.
Back to the top
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Back to the top
Keywords: 
kbprb KB281664
Back to the top