Eric Johnson : SQL Server 2008, SSIS

Virtual Classes

ejohnson2010 — Tue, 26 Oct 2010 20:50:18 GMT

I have two online classes starting on November 1st that I recorded on the SSWUG.org vClass platform. The first is “Introduction to SQL Server Replication” and is a 12 session class on all things replication. Cost is $199……for more information or to register,...(read more)

SSIS Virtual Class

ejohnson2010 — Thu, 13 May 2010 17:54:39 GMT

I recorded a Virtual SSIS Class with the good folks over at SSWUG and the first airing of the class will by May 15th. This is 100% online so you can do it on your own time and from anywhere. The class will run monthly and I will be available for questions...(read more)

The Trouble with SSIS Sorting

ejohnson2010 — Wed, 03 Feb 2010 14:00:00 GMT

Many SSIS transformations, such as the Pivot and the Data Profiling Tasks, require that the data being fed into them be sorted. Without first sorting, some transformations will throw an error and not run, while others will run but the results will not...(read more)

Understanding the SSIS Package Protection Level

ejohnson2010 — Tue, 12 Jan 2010 17:46:05 GMT

One property of all SSIS packages that you must understand is the ProtectionLevel. This property tells SSIS how to handle sensitive information stored within your packages. Most commonly this is a password stored in a connection string. Why is this information...(read more)

Check Out My SSIS Screen Casts

ejohnson2010 — Mon, 14 Dec 2009 22:16:10 GMT

Two I did for TechTarget: Using the Pivot Transformation in SQL Server Integration Services: http://searchsqlserver.techtarget.com/video/0,297151,sid87_gci1374920,00.html Using package configurations in SQL Server Integration Services: http://searchsqlserver.techtarget.com/video/0,297151,sid87_gci1369995,00.htm...(read more)

SSIS Package Builds

ejohnson2010 — Tue, 08 Dec 2009 20:29:18 GMT

So you have written an SSIS package and now its time to package it up and send it off to your QA department. Excellent; you need to use the build function in Business Intelligence Development Studio. On the surface this is pretty simply but there are...(read more)

SSIS 2008: Looping Through Rows in a Table

ejohnson2010 — Fri, 13 Nov 2009 22:09:06 GMT

Inevitably when writing code, you have a need to write a loop in order to iterate over multiple objects. When writing code against a SQL Server, as we usually are doing in SSIS Packages, you often need to iterate over all the rows in a table. This can...(read more)

SQL Server 2008’s New Import and Export Wizard

ejohnson2010 — Mon, 19 Oct 2009 15:58:06 GMT

I have written a lot lately about SSIS package development, and that doesn’t apply to everyone that works with SQL Server 2008. So you might be asking, what’s does SSIS have to offer me, the production support DBA? Well, I am glad you asked. In SQL Server...(read more)

Working with SSIS Expressions

ejohnson2010 — Mon, 12 Oct 2009 16:47:38 GMT

In SQL Server Integration Services (SSIS) Packages, expressions are everywhere. You may have worked with Expressions in some of the transformation tasks, such as the Derive Column Transformation, but did you know they can also be used to set the properties...(read more)

Managing Lookup Cache in SQL Server 2008

ejohnson2010 — Tue, 29 Sep 2009 19:59:30 GMT

The Lookup transformation in SSIS has changed a lot in SQL Server 2008. One of the best new features is the ability to pre-build your cache which gives you a lot of control over what is cached and how the cached data is managed. The basic lookup offers...(read more)

Using SSIS Package Configurations

ejohnson2010 — Mon, 21 Sep 2009 15:55:37 GMT

SQL Server Integration Services (SSIS) is a very powerful tool for creating ETL Packages. Part of what makes it so powerful is its ability to use package configurations. Package configurations allow you to externally store information that the package...(read more)

SSIS 2008 and the New Lookup

ejohnson2010 — Wed, 01 Jul 2009 21:33:44 GMT

SSIS is a pretty useful tool for designing ETL processes. One of the transformations I was disappointed with in 2005 was the lookup. I found it a little better than the lookup functionality in DTS, but not too much better. Well, Microsoft must have read...(read more)