none
OLE DB Destination fails with illegal instruction RRS feed

  • Question

  • Environment: Server Windows 2003 SP1, VS 2005

    I ran into this problem trying to deploy an SSIS package to a development server.  I tested by creating a simple SSIS package on the server itself.  Two blocks an OLE DB Source block and an OLE DB Destination block.  Two tables in the same database, one the source, the other the destination.  Connection manager test connection works fine.

    Package will execute from the IDE (locally on the development server), source block will read the table subcessfully, but when the destination block executes it fails and will stay yellow in the status screen.  during the execution SQLDumper.exe is triggered.  Analyzing the dump tells me:

    (2b40.2938): Illegal instruction - code c000001d (first/second chance not available)
    eax=04008010 ebx=00000004 ecx=00000010 edx=00000000 esi=00000940 edi=00000000
    eip=7c82ed54 esp=0422f598 ebp=0422f608 iopl=0         nv up ei ng nz ac po cy
    cs=001b  ss=0023  ds=0023  es=0023  fs=003b  gs=0000             efl=00000297

    An illegal instruction was hit.

    This error exists when the destination block is either an OLE DB Destinaltion or a SQL Server Destination block and the SSIS application is executing locally.

    Strangely enough if I run this same SSIS application from my development laptop it works fine against either my local datbase instance (on the laptop) or against the development server (App running on laptop, DB on development server).

    I have scanned the forums and search engines for this type of error, so any assistance would be appreciated.

     

    Thanks...

    Wednesday, July 26, 2006 3:35 PM

All replies

  • do you have logging enabled?  if so, please post the exact ssis error message.
    Thursday, July 27, 2006 6:20 AM
    Moderator
  • Date  8/7/2006 12:48:57 PM
    Log  Windows NT (Application)

    Source  SQLDUMPER
    Category  (0)
    Event  5000
    Computer  SPT-TEST01

    Message
    EventType sql90exception, P1 dtsdebughost.exe, P2 2005.90.1399.0, P3 434f5df1, P4 dtspipeline.dll, P5 2005.90.1399.0, P6 434f5dbc, P7 0, P8 0004ba38, P9 00000000, P10 NIL.

    SSIS itself displays no error information except for the block turning yellow.....

    Monday, August 7, 2006 4:57 PM
  • I am getting the same problem:

    On a new development server installation Win 2003 R2 and MSDN SQL2005 Developer edition & SP1 (was a clean install) when using DTSWizard or a SSIS package in VS2005 on the server to transfer data onto a sql table (either from another table or flat file) I get a fatal error "Unhandled win 32 exception" - looking in the event log I get

    Faulting application dtswizard.exe, version 9.0.2047.0, stamp 443f5b0a, faulting module dtspipeline.dll, version 2005.90.2047.0, stamp 443f5a9c, debug? 0, fault address 0x0004c258.

    VS2005 on the server is

    Microsoft SQL Server Integration Services Designer
    Version 9.00.2047.00

     On my developer desktop I have VS2005 as

    Microsoft SQL Server Integration Services Designer
    Version 9.00.1399.00

    and I can build a project on this which runs ok from the desktop

    I do get version difference alerts if I try & load a SSIS project on the server when I initially made it on the desktop

     

    Any ideas?

     

    regards

     

    Friday, September 1, 2006 3:01 PM
  •  lwulfers wrote:

    Date  8/7/2006 12:48:57 PM
    Log  Windows NT (Application)

    Source  SQLDUMPER
    Category  (0)
    Event  5000
    Computer  SPT-TEST01

    Message
    EventType sql90exception, P1 dtsdebughost.exe, P2 2005.90.1399.0, P3 434f5df1, P4 dtspipeline.dll, P5 2005.90.1399.0, P6 434f5dbc, P7 0, P8 0004ba38, P9 00000000, P10 NIL.

    SSIS itself displays no error information except for the block turning yellow.....

    again, did you turn on ssis logging?
    Saturday, September 2, 2006 6:27 AM
    Moderator