SSIS Programming

  • Any clue on this?

     

    Hello,

    I developed  a simple package in order to copy a table from tableA(Oracle) to tableB in SQL2k5. The package is working fine when I tested. But, how do I redirect the error rows in a user-defined error table so that the user can view it. Also, I am calling this package in a program (written in C#) and add the 4 libs as reference in the program. This program will be running as Service. I am getting the following error when I try to install the service.

    "

    msxm16.dll failed to register. HRESULT - 2147023782

    Exit Setup / Try Again/ Cancel

    "

    What am I missing here?

    Any help will be greatly appreciated.

    Regards,

    Ram

  • Can't help on the dll issue. is that dll on the server?

    The first, see error output for destination and redirect error rows. See BOL for more info.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

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

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