Depending on which source adapter you are using, you can add new or existing sources to an integration. For ODBC and text sources, you may be able to add more than one source to an integration. For the XML source adapter, however, you can add only one source at a time. For this adapter, you need to remove the existing source before adding another source to the integration. See Removing a source from an integration for more information. If you try to add more than one source to an integration that contains an existing source, a message appears.
You also can right-click on the Sources item in the Integration window, and from the menu that appears, click Add Source. |
The window that opens next—a Properties window, a Source Settings window, or no window—depends on which source adapter and source you are using.
For more information about adding text and ODBC sources, see Using ODBC and text sources.
For more information about setting up XML source definitions, see Setting up XML source definitions.
After you select a source and, if necessary, set up source definitions and source settings, the source appears in the Integration window, and you can continue to build your integration.
You can drag a source file from the desktop or Windows Explorer onto the Integration Manager workspace and the Integration Source Properties window automatically opens. For the new source, the default Delimiter setting is Comma. Change the Delimiter and First Row Contains Column Names settings to match the file information. |