Hi am having trouble understanding data conversion in ssis. when should one convert data types,should I always convert or I only convert when ssis has data type compatibility issues?
Am struggling to understand if i should convert when i import from excel to sql server or from sql server to excel or from text file file to sql server or from sql server to text file etc?
Please help me understanding data conversion in ssis.
The need to convert data from one data type to another will largely be dictated by the business need for it. For example, the ID fields are usually Integers and need not be converted, but a phone number on the other hand may have "(" or hyphens that need to be removed before they are loaded onto your destination database.
SSIS offer's ways to convert data that will ultimately fit the pattern/datatype that you need it to be in. A comprehensive list of the supported data types is here