SQL Server Performance

DTS transform task with numeric datatypes

Discussion in 'SQL Server DTS-Related Questions' started by stephr1000, Feb 26, 2004.

  1. stephr1000 New Member


    I have a DTS package. It uses the transform task - the source is a Stored procedure and the destination is a flat file. At the moment I can consistantly generate a fatal error that will close enterprise manager but I believe I have narrowed this done to a datatype of numeric. I had about 15 columns of the datatype numeric. If I eliminate one the package does the transforming fine. I had the last column and the transform task will not render the destination flat file. If I convert all these fields to chars then it works fine. Anyone aware of what happens with the numeric datatype in a transform task and what kind of space limits I may be hitting with these columns?

  2. satya Moderator

    What was that fatal error you used to get?
    What is the level of service pack on SQL?

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. stephr1000 New Member

    sorry for the delay.

    We have SQL Server 2000 8.00.760 (SP3) and this one is running on Windows 2003.

    Error occurs when I hit the the destination Tab of a transform task and then hit the define columns button. The first error window reads
    Microsoft Management Console has encountered a problem and needs to close. We are sorry for the inconvenience.

    Next window -
    AppName: mmc.exe AppVer: 5.1.2600.0 ModName msvcrt.dll ModVer 7.0.2600.1106 Offset: 00033bba

    I do have a picture of the detailed error screen and could email it to you if you would like.

  4. satya Moderator

  5. stephr1000 New Member

    This morning I converted everything to be chars and this still does not work.

    If I transform to excel it works fine. If I take the excel sheet and then transform to the text file again the error.

    I just think I hit a size threshold in the GUI as the row size is about 400 characters long and that should be fine.

  6. satya Moderator

Share This Page