To connect to a MS Excel spreadsheet or MS Access database using ODBC there are several ressources available (e.g. http://www.clearpeaks.com/blog/etl/ms-excel-spreadsheets-as-a-data-source-in-informatica-powercenter)
I got a helpful "terminated unexpectedly" error message in the Workflow Monitor and couldn't find the error. Finally I found out that a little session property solved my problem.
I set the "Default buffer block size" to a value of 8 (for example) instead auf Auto and my Workflow terminated successfully.
thanks I had the same issue here
ReplyDeleteThank you so much! I was stuck with the same erroro.
ReplyDeleteVery nice and informative blog.
ReplyDeletehttp://www.tekclasses.com/