Technet Link to Identify SSIS Errors:
Refer to this MSDN Documentation site for obtaining detailed information about the Errors often encountered in SSIS Packages.
http://technet.microsoft.com/en-us/library/ms345164(v=sql.100).aspx

SSIS gameplan..

In this Introduction to SSIS, I will walk you through the basic ETL tasks.  ETL as Extract Transform and Load process helps as a good backend process to absorb and refine the data obtained from multiple source systems.   SSIS packages use multitude of “Transformation” tasks, each suiting a particular purpose in mind.

When we open BIDS and open a new SSIS project, a default package with name “Package.dtsx” is created by the application.

All packages have extension of “.dtsx”.  If while renaming a package, we forget to add this extension, the package is moved to “Miscellaneous” folder.

This leaning Tutorial spans into 9 parts,

Part 1: Control Flows and Connection Managers

Part 2: Data Flow Tasks

Part 3: Event Handlers

Part 4: Package Explorer

Part 5: SSIS Variables

Part 6: Package Deployment and Security

Part 7: Advanced Learning

Part 8: Useful resources

Part 9:  Q & A

Enough of the talk.  Let’s learn SSIS through web videos provided in the site!