Sample Header Ad - 728x90

Informatica Source Qualifier not working from Windows ODBC data source (system DSN) from Excel xlsx file

2 votes
1 answer
2848 views
**Reference:** https://community.informatica.com/message/62128 **Windows ODBC Workflow:** Windows > Control Panel > Administrative Tools > Data Sources (ODBC) > click "System DSN" menu > click "Add" > choose "Microsoft Excel Driver (*.xlsx) > Data Source Name: "aaaaaaaaa" Version: Excel 12.0 click "Select Workbook" button > choose xlsx file **Informatica PowerCenter Designer Workflow:** Sources > Import from Database > ODBC Data Source: "aaaaaaaaa" click "Connect" button > the button's name changes to "Re-Connect" **Error:** .. it doesn't seem to find the data in the worksheet ... I have 3 columns with 10 rows of data
Asked by JustBeingHelpful (2116 rep)
May 30, 2012, 05:14 PM
Last activity: Jun 21, 2012, 06:08 AM