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:

Force software to always run as admin without exposing admin password

We have many computers where users are not admin.

I need to run a .exe file but it always asks for Admin credentials. I want to avoid been called each time they run the file ....

Surfing the internet I found a solution that worked for me:

1. Create a shortcut to the Exe File

2. Enter properties of the shortcut and modify the "Target" field adding C:\Windows\System32\runas.exe /savecred /user:domain\administrator before the existing file path

Save and run it. You will be prompted to enter the password:

Enter the password.

Always use the link to run the application.

Note: this does not work for Windows 7 Home or Starter Edition

Samsung Printer: Error Code #C1-1311

Hi
I just got this error code on the Samsung ML5010-ND:

This was a toner problem. Toner is not evenly distributed.
Solution: Remove the toner and shake it a while.

If this does not work ... get ready to replace it.

How to open MDI files in Office 2007

Why do some people send MDI files instead of PDF I don't know! Anyway this morning I got a MDI file ....

Mount ISO as drive

A nice and FREE! application to do it: MagicISO ( http://www.magiciso.com/download.htm )

I just needed to install a program of which I have only the ISO disk image.

No need of any extra explanation, just install and play :-)