The first step in building an integration is to create the integration, which contains information about the sources, destination, and mapping.
The Integration window opens, and the Properties window for the integration opens.
Use any integration name that helps you and others easily identify the integration.
The integration description can provide information about the integration, such as a short description of the source and the destination, as well as a date or a time interval such as “monthly” or “daily.”
If you plan to add a text or an ODBC source, don’t use ODBC reserved words in the column names for the ODBC source or destination. These words can prevent the integration from running properly. For a list of ODBC reserved words, go to http://msdn.microsoft.com and search for “ODBC Reserved Words”. You’ll find a list of reserved keywords in Appendix C of the ODBC Programmer’s Reference.
You do not need to define the other properties on the General tab until later. In fact, you can’t define some of them, such as the destination edit mode, until you add a destination to the integration. From the Properties window, you also can add scripts to the integration (see Using scripts) and set properties for the integration log (see Managing logs).
The name of your integration is displayed in the Integration window.
If you are using a master level destination, select a destination edit mode in the Integration Properties window (Integration > <integration name> Properties) before you save the integration. See Running integrations for information about setting the destination edit mode
Integrations are stored in a database file. You can specify the location of the Integration Manager database file using the Options window. Choose Tools > Options to open the Options window.
See Adding sources to add a source to this integration.