Data conversion failed

Error Message:
[Flat File Source [1]] Error: Data conversion failed. The data conversion for column "CAMP_TA" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[Flat File Source [1]] Error: The "output column "CAMP_TA" (38)" failed because truncation occurred, and the truncation row disposition on "output column "CAMP_TA" (38)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.


Solution:

• We can find the column name which is causing the problem.
• Verify the ETL, where the error is occurring (during source extraction or Target Loading)
• Source extraction: If ETL is failed during source extraction.
• go to source (Oledb or flat file source) advance editor options.verify the column data type and length. verify the source (source table/file) column data type and length.
• Change the data type or length of the column based on requirement.
• Target loading
• Verify the source and target data type and length
• Change the data type or length of the column based on requirement.

An OLE DB error has occurred. Error code: 0x80040E14

Error Message:
[StagingLoad [26]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E14  Description: "Deferred prepare could not be completed.".
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E14  Description: "Statement(s) could not be prepared.".
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E14  Description: "Invalid object name 'dbo.Dept'.".


Solution:

• SSIS Package is unable to find the object "dbo.Dept".
• Go to connection manager and verify the database, which we have mention in the connection manager.
• Verify the table "dbo.Dept" availability in the database.

Oledb connection manager failed with error code 0xC0202009

Error Message:
[SrcExtraction [26]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "SrcServer" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[SSIS.Pipeline] Error: component "SrcExtraction" (26) failed validation and returned error code 0xC020801C.


Solution:

• In the error message we can find the connection manager name (Highlighted in the above error message) which is causing the problem. 
• Verify the user name and password, which are passed in the connection manager.
• Verify the server (Which is mentioned in the connection manager) availability.

Cannot open the datafile (0xC020200E)

Error Message:
[Flat File Source [1]] Error: Cannot open the datafile "D:\Taks\LookUpSource.txt".
[SSIS.Pipeline] Error: component "Flat File Source" (1) failed the pre-execute phase and returned error code 0xC020200E.

Solution:

• Check the file path availability
• Check the file name and extension.
• Verify the folder (File located folder) access permissions.

Folder access permissions check:

• Select required folder. 
• Right click and select properties
• Go to 'Security' tab.
• Select the user.
• Verify the read and write permissions.