Post reply

DTS Aborts With No Message

  • August 10, 2005 at 11:09 am

    #61182

    I continue running into a DTS bug, and I need to see if anyone else has any insights on it.

     
    When I create a DTS transformation that goes from a SQL query or view to a FIXED flat file, the DTS application consistently aborts right after I have keyed in the fixed lengths of all output fields.  It aborts with absolutely no error message, and it can be reproduced every time.  The whole DTS process just disappears. 
     
    I have run into this trying to do the exact same thing at a number of consulting assignments in the past, different companies, different SQL Server Databases, and have resorted to doing it another way, even though this is exactly what DTS is meant to do. There is evidently a serious flaw or bug in this part of DTS.
     
    I wonder if anyone else has run into this. 
     
    Thanks!
     
    Mark

  • August 10, 2005 at 1:27 pm

    #581169

    I ran into this a while back..and could never find any info regarding this error. Just out of curiosity..whats the latest sp installed ?

    Matt

    Mathew J Kulangara
    sqladventures.blogspot.com

  • August 11, 2005 at 5:53 am

    #581344

    One way I've gotten around it that works sometimes is to create a dummy flat file in the output directory and use that to map the fields and transformations. It doesn't always work and doesn't explain the bug, but it has helped...

     

  • August 11, 2005 at 7:19 am

    #581386

    This used to bug me to no end.  I believe it was fixed in service pack 4.

    FIX: DTS Designer may generate an access violation after you install SQL Server 2000 Service Pack 3

    http://support.microsoft.com/kb/814113/

     

    Dylan Peters
    SQL Server DBA

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

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