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
Last activity: Jun 21, 2012, 06:08 AM