I agree with the preceding posters: it's a very helpful article. It helped me unlock parts of SSIS I had no idea were there.

However the article could be a lot easier to follow if some of the shorthand was expanded to include more context, so as to be understandable for those who are not familiar with SSIS and the SQLServer 2005 tools.

For example, under "Accessing SSIS via SQL Server Management Studio (SSMS)", it says "We can connect to SSIS Service for various reasons via SSMS. To connect to SSIS we have to mention the server name without the instance of SQL Server." But it doesn't say that you need to go to "Connect / Integration Services" in order to connect. That took me a while to figure out.

Another example is where it says "Let's add a new data source. Right Click Data Source -> New Data Source -> Complete the Wizard (Use SQL server Authentication)" I cannot find where to right-click. The section title talks about a command-prompt utility, but it doesn't sound like it has a GUI, so the right-click must not be referring to that. (If we were supposed to right-click there, I imagine the article would tell us how to launch dtexec.) I'm looking at the SSIS package name in SSMS under Integration services server / Stored Packages / MSDB, but there's no "Data Source" to right-click on.

Similarly, below where it says "SSIS -> Variables", I would love to know where to find this. But I can't figure it out.

Again, this article looks to have a great deal of useful introductory information about SSIS to help a new user get off the ground. If the above points could be clarified to provide more thorough context "for dummies", it would be a lot more useful to people like me.

Thanks,

Lars