Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Connection required when requesting metadata

New: 17 July 2006

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399

Event ID

0xC0202022 (-1071636446)

Event Source

Not applicable

Component

Integration Services

Symbolic Name

DTS_E_CONNECTIONREQUIREDFORMETADATA

Message Text

An error occurred due to no connection. A connection is required when requesting metadata.

This design-time message indicates that SSIS Designer must connect to a data source to retrieve new or updated metadata for a source or destination, and that it is unable to connect to the data source.

Possible Causes

This message might appear because of one of the following problems:

  • You have disabled connections to data sources by enabling Work Offline from the SSIS menu in Business Intelligence Development Studio.
  • The data source is in fact offline, or the connection attempt has failed for another reason.

Turn Off "Work Offline"

Enable connections to data sources by turning off the Work Offline option. Ordinarily, SSIS Designer tries to connect to each data source that is used by your package to validate the metadata associated with sources and destinations. You may have enabled Work Offline from the SSIS menu to prevent these connection attempts, and to prevent the validation errors that occur when the data sources are not available.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.