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)