SSIS DataflowTask is failing because of the Truncation
-
Hi all, I have an SSIS package that is failing in DataflowTask, which is importing data from Excel sheet, but its failing for some Excels and passing for some other Excels, its automatically setting all strings with length 255 for DT_WSTR datatype, but 1. I am not sure if this datatype length is the reason or the file size is the reason for the failure as its not giving me any error message. 2. Because the package is successfully running if the file size is small, but not able to put the values if the File size is bigger, is it the Problem. I am running this Package using .Net Console Application and File is located on the NetWork Drive, is there anyway to increase the File size limit of the .Net Console Application, if that's the Problem. 3. And one more thing, on the Server where SSIS package is running, maybe doesn't have MS Office, can it be the problem? If that's the case what minimum Office tools should we install to be able to read the file? 4. Or is it the Format of the Excel files that's cause it to failure, I am not getting any error messages, please help me. Any advice a code snippet, a link or even a suggestion going to be very helpful - thanks in advance.
Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."