i running ssis package includes decimal in column of flat file. decimal being written decimal (16,6) field in sql server value being truncated @ decimal point. i.e. 12.45 12. no truncation warnings/errors appear.
i found lots of resources on how truncate items in ssis nothing troubleshooting things being unintentionally truncated.
i had never heard of viewers before. using viewer appeared ssis truncating numbers form text file/ fixed it.
thanks
Comments
Post a Comment