Is there any solution for automatically Column datatype conversion in SSIS
-
Hi All, I have an SSIS package, which is running fine when its run by using SSDT but when I am running using SQL Job or .Net library DtsRuntime, then it was saying success but not populating the values. When I researched it, I found that data type was not mapping properly between Source and Destination Columns. The Column length is taken by the mapping itself automatically and it is failing without giving me the proper error message. What can I do to avoid these types situations, please help me, when I have 20 or 30 columns, it is not easy for me to debug all the Columns and find out which one is having problem. Any snippet, link or even suggestion would be very helpful to me. Thanks in advance.
Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."