Synchronous and Asynchronous transformation

Synchronous transformation is quicker than asynchronous.

But merge join is faster than lookup sometimes, while merge join is asynchronous.

"A asynchronous component requires all the rows from the upstream component
before it begins processing the rows, to do some modification on the data,
and ususally generates a differant number of rows.

In a way, they act as both destination and source, thus they generate
different LineageID for the output columns. Since the mappings in the
downstream is done using the LineageID you need to restore these mappings."

Blocking, Non Blocking and Partial blocking

Non-Blocking

Audit

Character Map

Conditional Split

Copy Column

Data Conversion

Derived Column

Import Column

Lookup

Multicast

Percentage sampling

Row count

Row sampling

Script component

Partially Blocking

Data mining

Merge

Merge Join

Pivot/Unpivot

Term Extraction

Term Lookup

Union All

Blocking

Aggregate

Fuzzy Grouping

Fuzzy Lookup

Sort

Protection Level in SSIS

Protection Level

Error: 

Error: 0xC0202009 at Package, Connection manager "runeet2k8.sa": An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E4D  Description: "Login failed for user 'sa'.".

Solution: 

For providing protection to package , use Protection level as 'Dont savesensitive', which will clear the password from our connection manager,

which will cause our package to fail for login details of connection manager,

for managing this , we can use configuration file, and set password value while executing package through configuration file.

Use EncriptAllWithPassword, when need to give password to open a package