Overview of SSIS Package

Monday, December 14, 2009

  • The SSIS package is the unit of work that is retrieved, executed and saved.
  • Package is an organized collection of connections, control flow elements, data flow elements, event handlers, variables and configurations.
  • SSIS includes SSIS Designer and SQL Server Import and Export Wizard, in addition to the SSIS object model for creating packages.
  • A package typically includes at least one connection manager.

0 comments:

Post a Comment

 
 
 
Your Ad Here