Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
In "Job Properties" -> "Owner" choose user by pushing button "..." should be like DOMAIN\Username not Username. Works? –  Justin Sep 6 '12 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 '12 at 12:23
add comment

migrated from stackoverflow.com Sep 6 '12 at 19:57

This question came from our site for professional and enthusiast programmers.

2 Answers

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.

share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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