SSIS notes

1. SSIS (SQL Server Integration Services) is an ETL (Extract, transform, load).
2. To create a new project, open BIDS (SQL Server Business Intelligence Development Studio) and pick "New Project..." from the "File" menu. Pick "Integration Services Connection Project" from the "Business Intelligence Projects." You will be taken through a setup wizard.
3. One may pull data from various sources, mess with it, and then put the transformed data to a database.
4. Projects have .dtsx extensions.
5. The ETL process may be kicked off by way of opening a folder and double-clicking a .dtsx, from within SQL Server, or by way of Windows Task Scheduler.
6. One may wrap multiple process step in transactions by way of "containers" with green and red outs.
7. One may create record sets based on the Deltas of two tables.
8. Control Flows orcestrate the overall steps while Data Flows orcestrate the row-by-row processing at a given step.