SQL Server Performance

SSIS Error

Discussion in 'SQL Server 2005 Integration Services' started by jhoy, Sep 1, 2008.

  1. jhoy New Member

    Hi All,
    I have a SSIS Package that is already working when I execute it using BID and DTExecUI utility it its local server where I created the package.
    But when i tried to exec the package in my local terminal the exact command are below.
    dtexec /sq DTS_Package /ser Server /U username /P password /l "DTS.LogProviderTextFile;"D:MSSQL.1error.log"

    Can anyone help me with this???
    Here is the error that it returned:
    Started: 8:10:14 PM
    Error: 2008-09-01 20:10:17.06
    Code: 0xC0016016
    Source:
    Description: Failed to decrypt protected XML node "DTS:password" with error 0
    x8009000B "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 err
    or. Verify that the correct key is available.
    End Error
    Error: 2008-09-01 20:10:19.17
    Code: 0xC0016016
    Source:
    Description: Failed to decrypt protected XML node "DTS:password" with error 0
    x8009000B "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 err
    or. Verify that the correct key is available.
    End Error
    Progress: 2008-09-01 20:10:19.75
    Source: Data Flow Task
    Validating: 0% complete
    End Progress
    Thanks and Regards,
    JHOY
  2. satya Moderator

    Check your package property called "ProtectionLevel". What is it set to?
    And save the package to sql server with protection level setting to be relying on sql server roles.
  3. jhoy New Member

    Hello Satya,
    Sorry I am not so familiar with SSIS..
    Where can I set "Protection level for the Package"???
    Thanks and Regards,
    JHOY[quote user="satya"]
    Check your package property called "ProtectionLevel". What is it set to?
    And save the package to sql server with protection level setting to be relying on sql server roles.
    [/quote]
  4. jhoy New Member

    Hi Satya,
    I am able to change protection level of the package..
    but i still got the ff error:
    The product level is insufficient for component "Flat File Source

  5. atulmar New Member

    Looks like SSIS itself is not installed on machine. There are some components that will be installed only if you are installing SSIS in your installation.
  6. jhoy New Member

    Hi Satya,
    Thanks for your help I am able to fixed my package error...
    Thanks and Regards,
    JHOY

Share This Page