I have a complicated ETL in SQL Server where part of the pipeline populates multiple fields from one DB to the next. The original problem is that these fields were designated as BIGINT in the destination table and Decimal(18,2) in the source table. The Figures would transfer, but only digits left of the decimal.
I have the ETL worked out so that the destination table has the same Decimal(18,2)data type, but whenever I execute the package all figures to the left of the decimal will populate but all figures to the right are 0 when it should reflect the CENTS Current figures look like this
326.00
556.00
751.00
They should look like this
326.54
556.89
751.44
This is SISS packages designed in Visual Studio. How do I get the 00's in the destination table to reflect the numbers in the source table?