THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSIS » SQL Server 2008   (RSS)
Showing page 2 of 3 (29 total posts)
  • SSIS 2008: Looping Through Rows in a Table

    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 be done using an SSIS Foreach Loop Container, but the how is not obvious. Making this work is a ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on November 13, 2009
  • SQL Server 2008’s New Import and Export Wizard

    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 2008, the Import and Export Wizard is built on the SSIS framework. In fact, at the end of the ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 19, 2009
  • Working with SSIS Expressions

    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 of many of the tasks and transformations, or even used to modify the values in your SSIS ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 12, 2009
  • Managing Lookup Cache in SQL Server 2008

    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 additional cache features such as Full, Partial, or even No Cache, but the real power comes in ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on September 29, 2009
  • Using SSIS Package Configurations

    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 needs so that information can be easily changed without re-writing the package itself. You can ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on September 21, 2009
  • Presenting at the PASS Application Development Virtual Chapter 8 Sep!

    Business Intelligence at RESTSeptember 8th at 1:00 PM EasternPresenter: Andy Leonard  I am honored to present Business Intelligence at REST to the PASS Application Development Virtual Chapter on 8 Sep 2009! This is going to be a fun presentation for me. I'm going to talk about my weather station and some business intelligence I've wrapped ...
    Posted to Andy Leonard (Weblog) by andyleonard on September 3, 2009
  • Presenting Incremental Loads, CDC, and SSIS 2008 to Columbus SQL Server UG Tomorrow!

    I'm honored to present Incremental Loads, Change Data Capture, and SSIS 2008 to the Columbus SQL Server Users Group tomorrow evening! This is the first remote presentation I've attempted in a while. I won't be in physical attendance, only virtually. I'll be in my office in Farmville, VA. Isn't technology cool? :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on July 8, 2009
  • SSIS 2008 and the New Lookup

    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 my mind because SQL Server 2008 has a new shiny Lookup transformation that is, in my ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on July 1, 2009
  • Presenting at New England SQL Server User Group!

    I am getting psyched about presenting to the New England SQL Server User Group in a couple weeks! On 12 Feb I'll be talking about Incremental Loads, Change Data Capture, and SSIS 2008. The bonus is I get to hang out with my friend Adam Machanic! If you read this blog and will be in the area, stop by and say Hi. :{> Andy
    Posted to Andy Leonard (Weblog) by andyleonard on January 28, 2009
  • Speaking at Raleigh Code Camp tomorrow!

    Code Camp RDU Fall 2008 is tomorrow (15 Nov 2008)! If you're going to be in the Raleigh area tomorrow and are interested in anything related to Microsoft technology, register and check out the sessions. I always have a blast in Raleigh! I will be presenting my popular session: Incremental Loads, Change Data Capture, and SSIS 2008. Hope to ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 14, 2008
Privacy Statement