Source FTP Connection

Using the XML Component, you can access documents across the Web using FTP. This option requires you to browse for a schema file, specify a sample document, or both.

To configure an FTP connection

  1. Typically, define a pre-configured "Sample" document that references the schema that you want to use. Connect to this document by specifying a valid Web address that points to an XML document. In the Source Document URL text box, type the address of the FTP server to which you want to connect. For example:

    ftp://www.scribesoft.com/target.xml

    In this scenario, the Schema file or URL text box defaults to the same file. If you prefer to browse for or specify a schema file, the source document that you also select must conform to the schema file's constraints.

    Note: The URL address must begin with "ftp://".

  2. Select whether to use Authentication for the connection.
  3. Type the user name and password, if applicable, then click Next to finish the wizard. The final wizard window appears, summarizing your selections.
  4. Click Back to change the selections, or click Finish to close the wizard.

The Workbench's Configure Source XML Component dialog box opens next, allowing you to configure the source side of your data translation specification ( DTS) files (*.dts), which load data from a source database to a target database. .

See also

Connecting to XML

Creating an XML Source Connection

File Connection Options

HTTP Connection Source