Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21

Thread: FTP TASK in SSIS

  1. #16
    Join Date
    Nov 2002
    Posts
    231
    Bye the way , Our sql server is Clustering with 2 nodes.

  2. #17
    Join Date
    Sep 2002
    Posts
    5,938
    Did you check sql agent error log to see if have any details?

  3. #18
    Join Date
    Nov 2002
    Posts
    231
    Yes, I just checked the SQL log and getting the below Error.

    SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000

  4. #19
    Join Date
    Sep 2002
    Posts
    5,938
    Not sure if it's related. Checked sql agent error log?

  5. #20
    Join Date
    May 2006
    Posts
    1

    Angry SSIS Doesn't save the password in the package by default

    I've also been having problems with this. It's down to which option you choose on the "ProtectionLevel" property on the package. Check what you have that set to, I suspect you have it set to EncryptWithUserKey which, obviously when you run it as another user doesn't work.

    Checkout these links and vote if you agree:
    http://lab.msdn.microsoft.com/produc...2-bc18e0568f2e
    http://lab.msdn.microsoft.com/produc...5-b5077f5f2380

    Hope that helps,

    Joel Mansford MCSE.

  6. #21
    Join Date
    Nov 2002
    Posts
    231
    Joel Mansford ,
    You are right. I'm able to execute the package after change the Protection level into EncryptSensitiveWithPassword. And also stored the package in msdb database with selection of the prtoectionlevel "rely on server storage and....".
    Micrrosoft should have provided more information related to this task.
    Thanks,
    Ravi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •