Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Running SQL SErver 2005 Agent job with SSIS package

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-10-06 : 07:39:06
Vladimir writes "I have tried to execute package running a job in SQL Server 2005. I have created Agent credential and proxy. I looked also into KB918760.
On execution the error is "Could not get proxy data to proxy id=1". The problem is there is no clear stepped instructions to make thing work.
I do not have problems running xact-SQL jobs. But running SSIS package jobs is completely different matter. Instructions on running dtuil to change ProtectionLevel in KB906562 are muddy, like
dtutil.exe /File %%f /encrypt file;%%f;3;<promissory password>

I need to set ProtectionLevel to ServerStorage according to KB918760. How can I figure that from command line above?

Your help is greatly appreciated.

Vladimir Kievsky"
   

- Advertisement -