SQL Server error - need help before all my hair is pulled out

[smueller72]

Hi all - I receive the error below at the end of one of my DTS packages. All steps in the package actually complete successfully but right at the end I get a Microsoft Visual C++ Debug Library pop-up with the following:

Debug Assertion Failed!

Program: c:\WINNT\system32\mmc.exe
File: dbgheap.c
Line: 1011
Expression: _CrtIsValidHeapPointer(pUserData)

my options are 'Abort', 'Debug', 'Ignore'.

Periodically when I get this error there is a DrWatson item written to the app log which reads:

The exception generated was c0000005 at address 10217A50 (strlen)

I've dug through the MS KB and can't find an exact match to this problem discussed.

I've completely rewrittent the package from scratch but still get the error. This is the only package that where this happens.

Any help would be greatly appreciated.

[Geeta]

Get the latest MDAC-SP3, might help.

[KnooKie]

can you break down your DTS package and build it up slowly bit by bit running it each time. You may be able to pin it down to something more specific.

[Geeta]

If you are using Workflows, execute Tasks written in VB in the main thread. This exception is caused due to heap overflow.(Tasks written in VB do not support free threading). As KnooKie suggested try to reduce the no of steps in the package/span them over 2 packages if possible and check the results.