Post reply

"Catastrophic Failure" Error in DTS

  • August 1, 2005 at 3:50 am

    #76391

    Dear Colleagues,

    I have a DTS package which copies 3 tables in sequqnce from Ingres Database on Unix server to SQL Server 2k.

    Source table name is identified using ActiveX scrip and assigned using "Dynamic Properties Task".

    The data is copied successfully for first two tables bu failes at the last i.e 3rd table giving the error, "Catastrophic Failure"

    Can anybody help me in this?

    Thanks in advance.

    Best Regards, Ansari

  • August 4, 2005 at 6:57 am

    #579536

    Have you tried setting the DTS Tasks to execute on the main package thread? (right click, workflow properties, options tab)

    Also, how many connections are you allowed to generate at once?  You might want to try to check the close connection on completeion check box as well...  I've seen this eliminate some issues when I have tried to connect to a datasource that only allows a limited number of concurrent connections.

     

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • August 9, 2005 at 10:01 pm

    #580898

    Hi Luke,

    Thanks very much for the reply.

    "Execute on main thread" option was already ckecked for each Task.

    I'll do the suggested setting i.e. "Close the connection on completion" and the try running.

    Regards,

    Asif

  • August 10, 2005 at 8:16 am

    #581045

    Hi Luke,

         I was experiencing this same "catastrophic error" when I was just simply trying to open my table in EM.  After downloading the service pack2 for sql server, my error went away.  Also, check out the MS Resolution for the problem.

    Good Luck!

     

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;q243349

    jm

Viewing 4 posts - 1 through 3 (of 3 total)

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