If the package is set to run in 64 bit mode, change it to use the 32 one. E.g. if you use the Agent it is there: Arthur My Blog

When I try to execute my package from a server it gives a sql dumper error log and stops. This is the error log that gets generated. Any help on this will be highly appreciated. (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 1: 45860 (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 2: 0 (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 3: 0:0 (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parameter 4: 000000000100FA40 (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Parsed parameters: (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 45860 (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0 (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0 (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0 (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x000000000100FA40 (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL> (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000 (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000 (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL> (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL> (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL> (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\100\Shared\ErrorDumps\SQLDmpr0030.mdmp (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'dbghelp.dll' : 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0' (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\dbghelp.dll' : '6.8:4.0' (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Location of module 'sqldumper.exe' : 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, File version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '2007.100:1600.22' (A6AC:9E48) 05/30/12 11:55:05, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Product version of module 'C:\Program Files\Microsoft SQL Server\100\Shared\SQLDUMPER.EXE' : '10.0:1600.22' (A6AC:9E48) 05/30/12 11:55:05, ACTION, DTExec.exe, Watson Invoke: No

If the package is set to run in 64 bit mode, change it to use the 32 one. E.g. if you use the Agent it is there: Arthur My Blog