A data source could be an Excel or similar spreadsheet where the data source is either an OleDB Jet connection for.xls files or and OleDb ACE for .xlsx files. We use these files using either the ODBC data source or the OleDB data source. To use you will have to have the appropriate software installed,
Using any ODBC data source and select statement, you can provide the data records to the transformation templates. you can use an SQL statement to get the data for the records passed to it. The dialog window looks like this. Connect String The connect string at the top tells the application how to get to
Using an OleDB data source and select, you can provide the data records to the transformation templates. you can use an SQL statement to get the data for the records passed to it. The dialog window looks like this. Connect String The connect string at the top tells the application how to get to the