Hello D Senapati,
Are you reading from Excel source when the PowerCenter Integration Service is running on UNIX? Then use an ODBC connection to SQL Server.
Are you using a sequellink driver to read from Excel or another ODBC driver?
What OS is the IS running on?
Are you getting any errors?
You can consider turning on ODBC tracing.
1 of 1 people found this helpful
If new rows are added to the excel spreadsheet, you need to re-define the name for these cells.
Please ensure the following steps are implemented within the Excel file source.
- Select all the cells you plan to import into PowerCenter
- Right-click the selected cells and select Define name
- Provide a name of your preference
After making these changes, please make sure the DSN created in 64-bit ODBC Administrator on Windows OS where the excel sheet resides, points to the updated excel spreadsheet.
Refer to KB 483664 for more information.