Open topic with navigation
For some datastores, you can update the source by selecting the connection for both the source and a target connection. However, not all connections can be used as a source and a target.
Note: Only valid connections display in the Connections drop-down list.
With a single object selected, you can:
Note: Some sources cannot be updated. If you select Update Source for a source that cannot be updated, an error message appears. In this case, you may be able to achieve the same effect by using the source connection as both a source and a target connection, and adding an update step on this target connection.
Note: If connection information is required for the selected connection, the appropriate login dialog box appears. Enter the login information and click OK to close the login dialog box.
Connecting to an ODBC source
Adding A Connection
Updating the Source
Using the Text Wizard