Microsoft KB Archive/281664

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

Article ID: 281664

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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 ' '.



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.

Keywords: kbprb KB281664

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.