Showing posts with label quotexecute. Show all posts
Showing posts with label quotexecute. Show all posts

Tuesday, March 6, 2012

"Execute Package Utility has encountered a problem and needs to close"

I'm a SQL Server 2000 user trying to get my head around v2005, in particular the changes from DTS to Integration Services.

I've build a few packages in BIDS and they work fine there, but saving them to either the file system or MSDB locations and running them in Management Studio results in:

Execute Package Utility has encountered a problem and needs to close. We are sorry for the inconvenience.

If I click on the debug button, I get this:

An unhandled exception ('System.IO.FileNotFoundException') occurred in DTExecUI.exe [404].

I've searched the Internet and found a few people who has also experienced this, but not received any answers.

Is there a kind guru out there with some idea of what is going on? Preferably something that doesn't involve re-installing, because the database has already been configured for our Blackberry users and I can't re-do it now.
I have the same problem... have you got a soln yet?

Thanks|||I also get the same problem. Looking in the event log, it is appears it cant find a temp file...but that doesnt make sense to me. Any solutions?|||I had the same problem. It got fixed after applying SP2.

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