Looking for some good SSIS info? Then this resource list is the place to start. I’ve collected together a whole range of resources that will help anyone to get started.
SSIS Performance Resources
- Performance and Tuning White Paper: White paper written by Elizabeth Vitt, put together for SSIS 2005 but still useful.
- Jamie Thomson SQL Bits: Video of SQL Bits Session on data flow performance
Custom SSIS Components
Whilst there are some obvious advantage of using closed source custom components I would always be slightly weary of using them myself. It is unlikely that they will continue to work when subsequent versions of SQL Server are released and you don’t want your upgrade to be dependent on the release of an updated version.
But if that doesn’t put you off:
- PragmaticWorks: Five free components and a load of commercial ones
- Konesans: A range of components from the SQLBI.com boys
- CozyRoc: A whole load of commercial components
- Red Gate: To date they have one component in Beta, the data cleanser
- Codeplex: Community list of tasks and components
Writing Your Own Custom Components
If you don’t want to pay out a load of cash and want to know that you have the source code available to upgrade or alter a component, you can always create your own:
- Microsoft Documentation: A good source of information, but not the best set of instructions to get started. A useful reference.
- More from Microsoft:Building, Deploying, and Debugging Custom Objects
- Dave Ballantyne at SQL Bits 8: I found this more useful when starting out
- CodeProject: Another Example
- Professional SQL Server 2008 Integration Services: Prefer a good old fashioned book, this will be the one to get.
- SQL Server Central: Another good case study with code examples and a few more links at the end.
- Darren Green and SQL Bits: Slide Deck and example code
SQL Server Integration Services Blogs
Here are some prominent bloggers who post on SSIS:
- SSIS Junkie: Jamie Thomson
- SQLIS: The community branch of Konesans Ltd, our SQL Server and Business Intelligence consultancy
Know any other good SSIS related blogs? Want to get yours added? Let me know!
SSIS Forums