Upgrade SSIS 2005 to SSIS 2008

  • My jobs was running perfectly from last 3 months. But suddenly from yesterday my jobs started throwing warning message

    Error Message :: ...........................0.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 09:00:00 Warning: 2014-05-07 09:00:00.29 Code: 0x80019316 Source: Package Format Migration Module Description: The provider name for the connection manager "CON_SRC1" has been changed from "SQLNCLI.1" to "SQLNCLI10". End

    Warning: 2014-05-07 09:00:00.29 Code: 0x80019316 Source: Package Format Migration Module Description: The provider name for the connection manager "CON_TGT1" has been changed from "SQLNCLI.1" to "SQLNCLI10". End

    There is no change on server configuration except Microsoft SQL Server 2008 R2 Native Client installation.

  • amit_adarsh (7/1/2014)


    My jobs was running perfectly from last 3 months. But suddenly from yesterday my jobs started throwing warning message

    Error Message :: ...........................0.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 09:00:00 Warning: 2014-05-07 09:00:00.29 Code: 0x80019316 Source: Package Format Migration Module Description: The provider name for the connection manager "CON_SRC1" has been changed from "SQLNCLI.1" to "SQLNCLI10". End

    Warning: 2014-05-07 09:00:00.29 Code: 0x80019316 Source: Package Format Migration Module Description: The provider name for the connection manager "CON_TGT1" has been changed from "SQLNCLI.1" to "SQLNCLI10". End

    There is no change on server configuration except Microsoft SQL Server 2008 R2 Native Client installation.

    Microsoft SQL Server 2008 R2 Native Client is SQLNCLI10, which means your packages are upgrading from an older native client configuration to a newer one.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply