Helping myself and other beginners gain a better understanding of SSIS
I want to show my understanding and the methods I found from
the Internet and colleagues to explain the concepts of SSIS. The reason I am
doing this blog is because I want to leave a little bit of a guide for myself.
If this blog sheds some light on the functionality of SSIS for you as the
reader then that is great.
Some of the blog tutorials I have gone through are either
are very vague and sometimes can’t be easily followed, other blogs have too
much information and takes a lot of effort to maintain attention on the
tutorial. I want my tutorials to be concise and easy to follow. Another reason
for the creation of this blog is so that I won’t be constantly searching the
internet for stuff I used before in my SSIS projects.
During this blog I will be using SSIS 2008. I will be
splitting the project into smaller more comprehensive components to allow you
to navigate to the parts that you do want. I will add the sources/references I
used in my project at the end of this blog.
I will also put a full project at the end of this blog
Components of SSIS
My understanding of a variable is that it is a container for a specific data type. In SSIS, a variable will have a name so that it is easily identifiable (ideally). The scope of the variable will determine if the variable can only be seen in one item or multiple items from the toolbox or even the whole package.
The data type of your variable determines what can be allowed. If the data type is an int type then it can only accept whole numbers.
The value can be seen as what the variable is containing at this moment.
I haven’t altered many of the options on the properties window. I mainly use it to change “Delay validation” and “Expression” property on items from the Toolbox.
Basic solutions for common things you want to do in SSIS
Tips/ My general guidelines
· Name your stuff properly from the beginning, it’s a pain trying to rename your variables because SSIS does not automatically change it for you. It then becomes a scavenger hunt once you start renaming variables.
· Understand your data and what data types are needed