Hi There, I have a flat file in which the data is cut into fixedwidth like This is Amount data field in which the data is cut into 10 digits like "0000060000" and this is loading in SQL Server Table like "60000.00" but the desired output / expected amount is 600.00. What is going wrong ? Note : The Datatype i've used for this field in database is Decimal(12,2) In Short : Data comming from TextFile : 0000060000 Data Loading into SQl Server : 60000.00 Expected Results : 600.00 Dotnet.Explorer

I'm going to go out on a limb. There is no decimal place in your number. I would suggest that you use a Derived Column transformation. You just divide the the value in that column by 100.Russel Loski, MCITP Business Intelligence Developer and Database Developer 2008

Thank You Russ !! That Worked Dotnet.Explorer