Back to Blog
    sql-server-2005
    service-pack
    ssis
    database-mirroring
    historical

    Service Pack 1 Released!

    Brian KnightApril 20, 2006

    Historical article

    • Original title: Service Pack 1 Released!
    • Author: Brian Knight
    • Original publication date: April 20, 2006
    • Originally published on: White Knight Technology
    • Preservation note: This article preserves the SQL Server 2005 Service Pack 1 announcement and product details recovered from the Wayback snapshot.

    Archive provenance: White Knight Technology Historical Archive

    SQL Server 2005 Service Pack 1 had arrived with many fixes. Its largest enhancement was database mirroring, which added high availability by sending database transactions to another server in real time.

    The service pack also included numerous SSIS fixes and enhancements:

    • The Import/Export Wizard was easier to use in scenarios involving multiple tables.
    • IDtsPipelineEnvironmentService gave custom data-flow components programmatic access to their parent Data Flow task.
    • Analysis Services interoperability was improved. The DataReader source converted System.Object columns to the SSIS DT_NTEXT type; a Data Conversion transformation could then change the column to a more suitable type.
    • Performance improved for transformations including Sort.
    • The designer allowed a user to right-click a Dataflow and choose Execute Task, without first returning to the control flow.
    • The Expression Builder dialog received a public, documented API, giving task developers better access to expression-related objects.
    • A registry-based policy controlled package signatures at execution time. Administrators could disable loading unsigned or untrusted packages and distribute those registry settings with Windows Group Policy.
    • The Flat File source's Advanced Editor added UseBinaryFormat for loading packed-decimal data into the pipeline for processing by a script or custom transformation.
    • The DataReader source's Advanced Editor added CommandTimeout, allowing its time-out period to be adjusted for long-running operations.
    • Variable property expressions could be created or changed by opening Expression Builder from the Properties window.
    • Annotations could be added to precedence constraints.

    The original post pointed readers to Microsoft's historical SQL Server 2005 SP1 page: http://www.microsoft.com/sql/sp1.mspx. Brian described the service pack as a must-download for SQL Server 2005 users at the time.

    2026 Update

    SQL Server 2005 Service Pack 1 and every product detail above are historical. They do not describe a supported current SQL Server or SSIS release. Use documentation and servicing guidance for the exact supported version in use today.