- 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
- Event firing from C# script task
- Catching events in C# executor.
- 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
Tuesday, August 4, 2015
SSIS - Index of features
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment