locked
Exportação sql 2008 64bis para sql 2008 32 bits RRS feed

  • Pergunta

  • Olá,

    Estou tentando exportar dados utilizando o SSIS de um banco sql20008 64b para um sql2008 32b mas não estou conseguindo na hora de criar os jobs. Segue abaixo o erro:

    Executed as user: NT AUTHORITY\NETWORK SERVICE. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 64-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  6:34:55 PM  Error: 2012-01-04 18:34:55.26     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2012-01-04 18:34:55.28     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2012-01-04 18:34:55.28     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2012-01-04 18:34:55.28     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2012-01-04 18:34:55.29     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2012-01-04 18:34:55.39     Code: 0xC0202009     Source: Exportar_Dados--- Connection manager "sti-sv1.Rastreamento.sa1"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.  An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E4D  Description: "Login failed for user 'sa'.".  End Error  Error: 2012-01-04 18:34:55.39     Code: 0xC020801C     Source: Data Flow Task 1 Source - Query [1]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "sti-sv1.Rastreamento.sa1" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.  End Error  Error: 2012-01-04 18:34:55.39     Code: 0xC0047017     Source: Data Flow Task 1 SSIS.Pipeline     Description: component "Source - Query" (1) failed validation and returned error code 0xC020801C.  End Error  Error: 2012-01-04 18:34:55.39     Code: 0xC004700C     Source: Data Flow Task 1 SSIS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2012-01-04 18:34:55.39     Code: 0xC0024107     Source: Data Flow Task 1      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  6:34:55 PM  Finished: 6:34:55 PM  Elapsed:  0.156 seconds.  The package execution failed.  The step failed.


    José de Arimatéia
    quarta-feira, 4 de janeiro de 2012 20:40

Todas as Respostas

  • José,

    Qual é a versão do SSIS instalado na sua máquina?

    Você possui as duas instâncias instaladas na mesma máquina?


    Pedro Antonio Galvão Junior [MVP | Microsoft Evangelist | Microsoft Partner | Engenheiro de Softwares | Especialista em Banco de Dados | SorBR.Net | Professor Universitário | MSIT.com]
    quinta-feira, 5 de janeiro de 2012 12:29
    Moderador