Subscribe To

Subscribe to SQL Server and XML by Email

Tuesday, June 13, 2006

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!


Post a Comment

About Me
Jacob Sebastian
* XQuery Tutorials
My Links
SQL Server White Papers
SQL Server 2008
My Articles
XML Workshop RSS Feed
Contact me
Free Hit Counter
Web Site Hit Counters
SQL Server Bloggers
Blog Directories
blogarama - the blog directory Programming Blogs - BlogCatalog Blog Directory
Copyright Jacob Sebastian