ssis 调度

Question

package A中利用execute package tast 执行package B, package B中含有到另一台主机数据库的连接(需要密码),
sql server agent中建立一个job,file system调用package A,错误日志如下. 请问如何解决这个问题



Error: 2009-12-29 10:26:26.28
   Code: 0xC0016016
   Source: 
   Description: Failed to decrypt protected XML node "PackagePassword" 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: 2009-12-29 10:26:26.35
   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

Answer 1

package A 在vs2005中可以执行成功, 但job调度后就报错

Answer 2

如果还需要更详细的信息,请提出......

Answer 3

Have to type pwd when run the package?

Answer 4

对,就是这各问题.
如果我对package B设为 encrySensitiveWithPassword 并设置pwd,在sql server agent中直接调度package B(这里会提示输入package B)的pwd, 这时 package B可以正常运行.
但从package A利用execute package task 执行package B, 直接VS2005中可运行成功(package B设为encrySensitiveWithPassword会报错,设为默认的encrySensitiveWithUserkey运行成功)
,但在job添加step时不会提示输入密码,也就报错了

Answer 5

Can you use windows authentication?

Answer 6

觉得说得不清不楚的 再详细一点
如果我对package B设为 encrySensitiveWithPassword 并设置pwd,在sql server agent中直接调度package  这时 package B可以正常运行(添加step时会提示输入package B的pwd)
但从package A利用execute package task 执行package B,package B设置同样为 encrySensitiveWithPassword,这时 package A直接在VS2005中运行失败,package B设置为默认的 encrySensitiveWithUserkey 在VS2005中运行成功,但在sql server agent的 job调度中运行失败 错误日志如正文所示

Answer 7

我现在的目的是在package A中利用execute package task 执行package B,sql server agent里建job调度package A 如何能成功

Answer 8

Sql job can't handle interactive step, that's why you should make some change.

Answer 9

对于密码加密的ssis包, 在job step 里面, 你切换一下选项卡, 例如切换设置参数的项, 就会出来密码输入提示框.

Answer 10

另一台主机数据库不是SQL SERVER,所以不能用windows authentication

Answer 11

不行啊 还是不能运行成功

Answer 12

请高人指点 怎么完成对加密包的调度

Answer 13

package A中利用execute package tast 执行package B, package B中含有到另一台主机数据库的连接(需要密码),
sql server agent中建立一个job,file system调用package A,错误日志如下. 请问如何解决这个问题



Error: 2009-12-29 10:26:26.28
   Code: 0xC0016016
   Source: 
   Description: Failed to decrypt protected XML node "PackagePassword" 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: 2009-12-29 10:26:26.35
   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

楼主，您好，
请参考这个帖子，
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/fa967506-eed1-4991-b0bc-3ab99d8ead36
上面的帖子说要调整Protection Level,请按照这篇文章调整下Protection Level,然后再测试下：
http://msdn.microsoft.com/en-us/library/ms141747.aspx