Tag Archives: package

Find and update the owner of SQL Job, Maintenance Plan

When we update Maintenance plan, ownership of the job will be changed back to plan owner (In my case it was inactive account resulting job failure). This is a known bug in SQL Server 2005 and SQL Server 2008. (Ref: … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , | Leave a comment

SQLServer-SSIS-Wrong execution status- MaximumErrorCount

I was investigating abnormal behavior of SSIS package, the package completed successfully but failed to complete actual dataflow task. MaximumErrorCount value was the culprit, its value changed from 1 to 1000! Changing MaximumErrorCount value from 1 to X indicates SSIS … Continue reading

Posted in SQL, SQL Error, SSIS | Tagged , , , , , | Leave a comment