October 2010 - Posts

• Calling Child Packages in SSIS

  Calling an SSIS package from another SSIS package is, on the surface, a simple task. You just use the Execute Package Task and point it to a package on a SQL Server or somewhere in the file system, as shown below. It is pretty simply right? But what if Read More... Posted Thursday, October 28, 2010 12:48 PM by ejohnson2010 | 8 Comments Filed under: SSIS, SSIS Configuration, Child Package, SSIS Variables

• Virtual Classes

  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... Posted Tuesday, October 26, 2010 3:50 PM by ejohnson2010 | 1 Comments Filed under: SQL Server 2008, Training, SSIS, SQL Server, Replication

• The SSIS Pivot Transformation

  The Pivot transformation is one of the most useful transformations in SSIS, and also the biggest pain to configure. It comes with one editor, the Advanced Editor, so no pretty GUI here. Let’s walk though an example and hopefully it will help you learn Read More... Posted Wednesday, October 20, 2010 12:47 PM by ejohnson2010 | 5 Comments Filed under: SSIS, SQL Server, Pivot

• TSQL TRY…CATCH

  Transact-SQL is a great language for data manipulation, but it has its weaknesses. Unlike “real programming languages” T-SQL is confined to procedural code. Sure, you can build “modules” by using stored procedures and functions, but for the most part, Read More... Posted Tuesday, October 12, 2010 12:46 PM by ejohnson2010 | 4 Comments Filed under: T-SQL, Error Handling

• Working with Text Data Sources

  A common source for SSIS packages is the flat file. These are just plain text files that are delimited by some character such as a comma, pipe, or tab. The problem is when you connect SSIS to a flat file it assumes a few things about the file, specifically Read More... Posted Tuesday, October 05, 2010 8:00 AM by ejohnson2010 | 1 Comments Filed under: SSIS, SQL Server

• Data Conversion in SSIS

  When it comes to converting data from one type to another in SSIS, you have a few choices of methods. We are going to look at a few options and discuss the differences. With all of these, we are assuming that the input data type is compatible with the Read More... Posted Friday, October 01, 2010 1:43 PM by ejohnson2010 | 5 Comments Filed under: SSIS, SQL Server