I am loading data from Ms access DB to the SQl Server 2008, using SSIS 2008.
I am getting below warning message while executing the package and eding up loading half of the data nd failing the package.
Truncation may occur due to retrieving data from database columns
I have given proper data type lengths, also the incoming data donot have the data beyond the actual lenght, this is verified.
Source file, MS access.. I heard Imex =1 is a solution, but looks like that works only for Excel.
What is the solution, stuck here.. Need help asap.