Schedule an SSIS package

If you have ever tried to create an SSIS package and tried to schedule it with SQL Server 2005 Jobs, I assume, u must have came across an error which says the job could not be executed. It happened to me too. I did not spent time on troubleshooting it due to the tough time line I had. I used windows task scheduler to run the SSIS package as a workaround and thought of looking into it on a later time. Luckily, I just saw a codeproject article which explains how to fix the problem. The job fails because of the security checks that SQL server 2005 does before executing the package. The above article explains the details. Hope this helps!