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?
DOMAIN\Username
notUsername
. Works?