Tuesday, August 4, 2015

SSIS - Index of features

  • Creating package
    • Programmatic creation - https://msdn.microsoft.com/en-us/library/ms345167(v=sql.110).aspx
  • Variables & Parameters
    • Inbuilt System variables list -https://msdn.microsoft.com/en-us/library/ms141788(v=sql.105).aspx
    • System::ExecutionInstanceGUID - The unique identified generated each time a SSIS package executed. This id can be used to correlate the operations and logs in SSIS package.
  • Control flow
    • If condition in package - No out of the box support. Add expression into Disabled property of task
    • For loop http://www.bidn.com/blogs/TomLannen/bidn-blog/2640/ssis-for-loop-containers-part-1
    • Script task
      • Using variables and Parameters in C# script task.
  • Event handling
  • Running package
    • Run the package and capture events using C# .Net.
      • https://msdn.microsoft.com/en-us/library/ms136090(v=sql.105).aspx
    • Run the package by passing parameter values.
    • Run the package by modifying logging file path connection
    • Run the package by injecting logging provider and connection manager
      • https://msdn.microsoft.com/en-us/library/ms136023.aspx
  • Logging
    • Logging from C# script task
      • https://msdn.microsoft.com/en-us/library/ms136131(v=sql.120).aspx
      • Enable logging of script task log entries
    • Logging into sysssislog table.
  • Extending SSIS

No comments: