The package execution returned DTSER_FAILURE (1)

Frustrating!
SQL Server 2014 - 64 Bit
My dtsx package works fine if run manually but no way to schedule it on SQL Server Agent.

Solution was easy: Use 32 bit runtime!
On SQL server Agent - Jobs view your Job Properties and select:

Prevent saving changes that require table re-creation

Today I was trying to change the structure of a table in SQL server and I could'n! I got the error: "Saving changes is not permitted" !

Brief googling and I I found the solution:
On SQL server Management Studio go to Tools–>Options->Designers and un check the option "Prevent saing changes that requires table re-creation"

Done!

SQL Server 2005 - How to Rebuild Indexes periodically

Rebuilding indexes speeds up searches into a SQL Database. Your applications will benefit!
Index is not rebuild unless you tell SQL server to do it.
I have found quite useful to create a maintenance plan.ù
Right-Click on Maintenance Plans and create a new plan:

Undem Maintenance Plan Tasks (left) drug to the workspace the "Rebuild Index Task" 

and then doubleclick to get the properties:

Customize your task. You can select DBs to reindex.
With the Calendar icon schedule how often you wish it to run.

Note: plans will then appear in the Jobs Area: