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:
Thursday, January 22, 2015
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:
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:
Tuesday, January 20, 2015
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!
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!
Subscribe to:
Posts (Atom)
-
Hi I just got this error code on the Samsung ML5010-ND: This was a toner problem. Toner is not evenly distributed. Solution: Remove ... -
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... -
I just re-installed my PC. I use 3CX as soft phone connected to our company IP PBX. How can I move my settings from the old PC to the ne...