SQL Server Performance

SSIS Package Failing On Start- HELP!!!

Discussion in 'SQL Server 2005 Integration Services' started by sql_jr, Mar 26, 2009.

  1. sql_jr New Member

    Hi, Forum: PLEASE HELP ASAP!
    I set up a simple SSIS package via the Import/Export wizard, saved with "DoNotSaveWithSensitvePW", scheduled it as a job.
    And whether it runs through the scheduled agent, or I invoke it manually, I get this error:
    Description: Failed to decrypt protected XML node "DTSassword" 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
    I've seen a lot of confusing google hits, that talks about proxies, etc. so, I need exact steps 1,2,3....etc. The account(s) I use are sysadmin.
    Await reply!
  2. MohammedU New Member

  3. sql_jr New Member

    Many thanks, Mohammad! I will try this (the only thing I haven't tried) and post back results.
    In the meanwhile, I tried this with no success:
    http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx

    The only thing I couldn't/didn't do is set up the credential for a WINDOWS account. I can only use SQL Authentication here. Is this a necessity? Not sure if this is just the author's example. Please advise, THANKS!
  4. sql_jr New Member

    Hi, i tried your suggestion and so far no good. I forced the job step to go back to using the SQL Server Agent account instead of proxy.
    Could not find file 'C:Documents and SettingsmyprofileLocal SettingsTemp mp32.tmp' Why they're lkg for temp file I don't know.
    When I force it to use my setup proxy, it says cannot find data for proxy. H-E-L-P!
  5. satya Moderator

    Have you checked whether that PROXY account has required permissions on the referred folder?
  6. sql_jr New Member

    thx, Satya. I am storing/running the package from SQL Server - is it a requirement that I run from file system? Otherwise, what folder would I give proxy permission? Can you list steps? Regards!

Share This Page