Steve,

As per your suggestion I apply the changes and it worked.

My scenario was as follows:

Transferred the tables from Oracle into SQL Server 2005 and save the SSIS Package...