This post explains about creating a SSIS package for demonstrating the small ETL process using transforms and connections in SQL server 2005. 1. Create a new SSIS package and drag a DataFlow task onto the control flow. Double click the task to go to the Data Flow tab. 2. In the Data Flow tab, drag an OLEDB Source onto the design pane. Select the data connection to Adventure Works...