The Navision 4.0 ODBC-driver gives following error when connecting in ssis :
"Internal error 182 in module 1."
The driver doesn't like multi-threading behavior . In DTS2000, this issue could be solved by turning on the workflow-option "Execute on main package thread" !
I was wondering... is there a way to do this also in SSIS ?
Kind regards
Geert G.Interesting issue, for which I have no sure answer. Looking at the properties we have you may like to try the MaxConcurrentExecutables property at the package level, and the EngineThreads property for the Data Flow. These would I assume limit you to one thread, but if that is the main one, I have no idea.|||
Thank you for your reply
Unfortunately when I try to change the 'EngineThreads' to 1, following error occurs:
"Could not set the property value: Error at Data Flow Task [DTS.Pipeline]: The EngineThreads property of the Data Flow task must be between 2 and 60. An attempt was made to set the property to a value that is too small."
Even changing MaxConcurrentExecutables to 1 or 0 doesn't solve the problem
|||Sorry I didn't test this. Better ask someone who knows what they are talking about. Product Team over to you....
No comments:
Post a Comment