Looking at the SSIS section on my blog I felt that SSIS has not been represented fairly. It has far less articles than SSAS! Over the years I have encountered several interesting stuff in SSIS, hence there are a few SSIS articles I’d like to write. Some are of basic type; some are more of architectural type.
The basic ones are for example: (I will put the link here one by one as I completed them)
- export a query result into a file Link
- load a file into an existing table (upsert)
- set the value of a variable from database Link
- set the value of a variable from a file Link1, Link2
- find the latest file
- dealing with the file footer/header
- import an Excel file – problem with alphanumeric column
- removing a column that was deleted from the table
I found that some people are having difficulties finding an example that they can copy. I believe that we human “learn by example”. When people google something, they want to find an article with an example that they can copy/do. Not lengthy explanation about how it works. But it is so difficult to find these examples, even for simple things, e.g. writing into a variable. So in all my coming articles I will write it to show it by example, rather than lengthy theoretical explanation.
The more of architectural ones are for example:
- Configuration parameter: parent variable vs xml approach – advantages/disadvantages
- Using custom task/component or child package to increase code reusability and maintainability
- Orchestrating an ETL batch using metadata approach
- Using a centralised message hub for DI/ETL rather than point to point approach. Particularly applicable / beneficial for large corporation.
- What’s new in SSIS 2011 – this one is not architectural 🙂
So in the next few weeks I will be writing them one by one. Hopefully they are useful for people who need them. As I finish each article I’ll put the link on the list above, as well as on the home page of course. If there are other topics in SSIS that you would like me to write, please let me know (email@example.com). There’s 1 Informatica article that I’d like to write: Importing a File with Dynamic Columns, i.e. like this but in Informatica.
Vincent Rainardi, 4/6/11
PS. Well, talking about unfair representation, SSRS, Informatica, BO, Cognos, and Teradata are also not represented fairly 🙂 – I have no articles on them. None! Well may be next time, after SSIS. Now I’m going to concentrate solely on SSIS (well, and data modelling).