Tuesday, March 6, 2012

"Execute on main package thread" (dts2000) still available on ssis ?

Hello Smile

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 Tongue Tied. 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 Big Smile

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 Smile

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 Tongue Tied

|||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