DTS transform task with numeric datatypes | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS transform task with numeric datatypes

Hi, 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? thanks!
What was that fatal error you used to get?
What is the level of service pack on SQL? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
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. Thanks.
Get help from this KBAhttp://support.microsoft.com/default.aspx?scid=KB;EN-US;814113 and apply the hotfix. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
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.
Any trials on the referred KBA HOTFIX? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>