When you add a new simple ODBC source to an integration, the Properties window opens. Use the following procedure to set the options on the General tab of the Properties window.
The name should describe the type of information retrieved by the ODBC query. The description should provide information about the source, such as what type of data is retrieved by the query or what data is contained in the source.
Don’t use ODBC reserved words in the source name. They can prevent the integration from running properly. For a list of ODBC reserved words, go to the MSDN online library (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.
Data Source This is the ODBC data source to retrieve data.
Table This is the table to use from the ODBC data source.