SSIS error occurred due to truncation occurred at Excel Source in SQL Server
Excel Source has a problem during running and throws the following error:
Excel Source ] Error: The "Excel Source.Outputs[Excel Source Output].Columns[Project SharePoint Site]" failed because truncation occurred, and the truncation row disposition on "Excel Source.Outputs[Excel Source Output].Columns[Project SharePoint Site]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
- Go to the Data flow tab and right-click the “Excel Source”.
- Go to the “Show Advance Editor”.
3. Go to the Input and Output Properties tab. Expand the Output Columns and select the column in which you need to change the datatype.
4. Select the column and change its datatype as follows: I increase the length to 4000 as i required and change to Unicode string[DT_WSTR]