![]() This adds 4 digits after the decimal point to the whole integers. I currently have this column defined as Decimal(12,4). One of the columns in this new table contains whole integer as wells as decimal values (i.e. Why is this does anyone know?Įxample: AutomobileTypeId (PK, decimal(10,0), not null) View 5 Replies View Related Data Type With Decimal Point For Decimal Values But Not For Whole Integers Dec 8, 2013 I noticed that in some places that they use decimal data types, that I would normally think they should be using integer data types. I am working with a legacy SQL server database from SQL Server 2000. ![]() Thanks View 4 Replies View Related Legacy Database Uses Decimal Data Types.-&> AutomobileTypeId (PK, Decimal(10,0), Not Null) Why Not Integers Instead ? Sep 26, 2007 How do I load that text file into a sql table. I have this flat text file that has a number of packed decimalįield type. Thanks! View 2 Replies View Related How To Load A Flat Text File With Packed Decimal Field To A Sql Table Apr 3, 2001 I've read several articles online that explain how packed decimal works, but none tell me how to interpret the last of my three examples. Has anyone got a function that can do this for me? The field contains values such as the following:. I have been able to load the data into a SQL2005 database table, but I now need to convert the Packed Decimal data in the binary(6) field to the appropriate integer (or float) value. I have been given some data from a Mainframe (AS400?) which has some fields coded in Packed Decimal. I've done a bit of searching to find a function for this, but I must be using the wrong words.Īny suggestions? View 1 Replies View Related Function Required To Convert Packed Decimal In Binary(6) To Int (or Float) Mar 8, 2007 The vendor that is receiving the file expects negative amounts to be in a packed decimal format. I have an stored procedure/DTS package that creates an output file that I FTP to a mainframe. View 13 Replies View Related Output A Packed Decimal To A Text File Mar 12, 2004 The destination decimal column type in the table is set as VARCHAR (I've tryed to set Integer with no success).Īny help on this will be apreciated. The problem is that in the destination table the decimals appear allways as NULL. I have been searching information in this forum in several threads and have downloaded a DLL from Īnd so far I've been able to get the "UnpackDecimal Data Flow Transformation" to work. I'm trying to load en EBCDIC file with packed decimal in comp 3 into a SQL table. Has anyone been able to convert packed EBCDIC decimal fields to ACSCII using SSIS? View 7 Replies View Related EBCDIC With Packed Decimal (Comp 3) To SQL Nov 26, 2007 ![]() The incoming data has packed decimal fields in it. I need to do EBCDIC to ASCII conversion in SSIS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |