Many thanks to everyone who attended this evenings sesion on SSIS. For those of you who want to go through the sample packages and reports I have attached the source code and powerpoint files to the end of this blog. Theres a readme.doc in the zip file with details on running them.
The attached file has some SSIS examples to demonstrate:
- parsing of sysdtslog90 table
- ssrs reports to analyse sysdtslog90 table
- custom audit tables
- custom data errors
- using semaphore files in workflow
I'm looking for some topics for my shiny new blog, so If you have any follow up areas you would like me to post on let me know via the comments