1

I have Windows 7 and SQL Server 2005 Version 9.00.1399.

I can successfully create an SSIS Package, however I am unable to execute it successfully as a scheduled job. When I run the job, SQL Agent reports Unable to start execution of step 1 (reason:Could not get proxy data for proxy_id = 1). The step failed.

All SQL services are running successfully.

The same kind of activity on Windows Server 2008 R2 Edition and SQL Server 2005 Version 9.00.4035 works successfully.

Does anyone know why this wouldn't work on Windows 7?

2
  • In "Job Properties" -> "Owner" choose user by pushing button "..." should be like DOMAIN\Username not Username. Works?
    – Justin
    Sep 6, 2012 at 11:41
  • 2
    It won't hurt to patch your SQL Server version. 1399 is RTM and SP4 is available. Had an issue with a coworker's SSIS execution yesterday wherein patch corrected the issue.
    – billinkc
    Sep 6, 2012 at 12:23

2 Answers 2

1

Probably the major problem is that your username don't have rights. There are some examples how to create Accounts:

SSIS run on different Account

SSIS runninng job

I would try set Owner "yourself" your PC Administrator user.

0

Thank you for your updates and help, as improving this solution, I found out the real problem and its actual rectification.

Solution was, we needed to install Service Pack 3 CD, then this issue got fixed. For the Windows 7 and server 2008 operating systems with as like you people referred the above.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.