DTLoggedExec has stopped working

Topics: Developer Forum, Project Management Forum, User Forum
Apr 29, 2010 at 2:03 PM

Hi

I am executing this command  and i am getting a msgbox staying that DTLoggedExec has stopped working. I am executing this is in server.

I have created the database perfectly and located the file as mentioned in the command line.Where i am wrong i dont know. ? could you help me.?

"E:\DTLoggedExec_v.0.2.3.0\DTLoggedExec\bin\Any\Release\DTLoggedExec.exe" /FILE:"E:\Mail.dtsx" /LE:E,I /PDF /PP:"E:\DTLoggedExec_v.0.2.3.0\DataFlowProfile" /PFN:"Mail" /LPA:"FILE=E:\DTLoggedExec_v.0.2.3.0\Log\Mail.dtsCSVLog" /LP:DTLoggedExec.LogProviders.

 

Regards

Karthikeyan.T

Coordinator
Apr 29, 2010 at 2:23 PM

Sure I'll try to help you.

After you get the msgbox with the "Stopped Working" error, you should also see some more detailed error (a .NET Exception) in the Command Prompt where you executed DTLoggedExec. IF you could post that, I can give you some advice.

Apr 29, 2010 at 2:46 PM

Hi  Manowar

This is the error.


Unhandled Exception: System.IO.FileNotFoundException: Could not load file or ass
mbly 'Microsoft.SqlServer.ManagedDTS, Version=9.0.242.0, Culture=neutral, Publi
KeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find t
e file specified.
ile name: 'Microsoft.SqlServer.ManagedDTS, Version=9.0.242.0, Culture=neutral,
ublicKeyToken=89845dcd8080cc91'
  at DTLoggedExec.Program.Main(String[] args)

RN: Assembly binding logging is turned OFF.
o enable assembly bind failure logging, set the registry value [HKLM\Software\M
crosoft\Fusion!EnableLog] (DWORD) to 1.
ote: There is some performance penalty associated with assembly bind failure lo
ging.
o turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fus

 

Thanks for helping me

Coordinator
Apr 29, 2010 at 2:54 PM

Ok I see. It's a binding error due to the fact that you're running on SQL Server 2008 and DTLoggedExec is trying to use SQL Server 2005 assemblies (this has ben done to allow execution on all platforms)

Here's the solution:

http://dtloggedexec.davidemauri.it/How%20to%20use%20DTLoggedExec.ashx

:)

Apr 29, 2010 at 3:46 PM

Thanks Manowar

It works.

Regards

Karthikeyan.T