Study resource for SQL Server 2008 R2 Integration services (SSIS)

 

SQL Server 2008 R2 Integration services (SSIS)

• Creating a simple ETL Package
  • http://msdn.microsoft.com/en-us/library/ms169917.aspx
  • Typical Uses of SSIS Packages
    • http://msdn.microsoft.com/en-us/library/ms137795.aspx
    • Package Protection Level Setting:
      • http://msdn.microsoft.com/en-us/library/ms141747.aspx
      • Running Packages:
        • http://msdn.microsoft.com/en-us/library/ms141708.aspx
        • Logging Package Execution:
          • http://msdn.microsoft.com/en-us/library/ms139845.aspx
          • Architecture of Integration Services
            • http://msdn.microsoft.com/en-us/library/bb522498.aspx
            • Architecture of an Integration Services Package
              • http://msdn.microsoft.com/en-us/library/cc645924.aspx
              • Package Deployment
                • http://msdn.microsoft.com/en-us/library/ms137592.aspx
                • Package Troubleshooting:
                  • http://msdn.microsoft.com/en-us/library/aa337088.aspx
                  • Managing Integration Services:
                    • http://msdn.microsoft.com/en-us/library/ms137731.aspx

 

References:

• Technical Reference:
  • http://msdn.microsoft.com/en-us/library/bb522642.aspx
  • Developer InfoCenter:
    • http://msdn.microsoft.com/en-us/library/ms137709.aspx
    • Integration Services Development:
      • http://msdn.microsoft.com/en-us/library/bb522537.aspx