Hi,
I am writing a data comparison code in python to compare the data transformed in the SSIS packages. So, I have all the modules written that accesses the each and every task in SSIS packages. It compares fairly well except for those data that have different datatype, same values but different decimal places. I started out converting both source and destination data as string and compare the string values.
But now I have these issues. I can get the data types(numerical values) of the source and destination columns; however, I was just wondering how do I get to use them with the regular variables that hold the data values. I know how to set the datatype for the SSIS columns but just dont know how to use with the regular python variable that hold column values.
Sagar