"Excel Connection Manager": The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered

Sometimes while importing data from Excel source following error is generated.This can be solved by using simple steps listed below.

Error Message-

 0xC0209303 at Package, Connection manager "Excel Connection Manager": The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.

Solution –

IN Business Intelligence Development Studio

Go to Project --> Project Properties --> configuration Properties --> Debugging -->

Run64bit runtime-

Set it to False.

Truncation error while executing SSIS package-Importing tables from different data sources.

Error Message-

0xC020901C at Data Flow Task, OLE DB Source [79]: There was an error with OLE DB Source.Outputs[OLE DB Source Output].Columns[XYZ] on OLE DB Source.Outputs[OLE DB Source Output]. 

The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".

Solution-

Double click on your source (oledb ,Flat file etc) --> OleDB Source Editer --> Error Output.

Select column having truncation error -->  set it to ignore failure.

Do the same for all columns having truncation error.

 Thats it now save and run the package.:-)