SSIS package not executing

  • Hi..

    I have created a simple SSIS package using ole db source and oledb destinations to copy data from one db to other.

    When m trying to execute this package..during execution a black screen comes 'C:\Program Files\Microsoft SQL Server\90\Shared\SQLDUMPER.exe' and then execution gets cancelled...

    what could b the reason and solution :-)...

  • secretshifter (6/15/2009)


    Hi..

    I have created a simple SSIS package using ole db source and oledb destinations to copy data from one db to other.

    When m trying to execute this package..during execution a black screen comes 'C:\Program Files\Microsoft SQL Server\90\Shared\SQLDUMPER.exe' and then execution gets cancelled...

    what could b the reason and solution :-)...

    This behavior is caused by internal crash, which was not handled properly by SSIS. The SQLDUMPER creates log of the error and stores it somewhere for later review. From your description it looks like you are not doing anything out of ordinary. Review the installed data providers and see if there are recent updates. Try a simpler data copy with less columns. It might be some particular type of column that is causing the crash.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply