Thursday, August 10, 2017

SQL - Cannot edit job steps

https://davidbridge.wordpress.com/2011/05/13/cannot-edit-job-steps-in-sql-server-2008-r2-management-studio-on-64-bit-windows/

Run cmd as administrator
Run these two lines
This will register 64 bit DTS.dll
c:\windows\system32\regsvr32 "c:\Program Files\Microsoft SQL Server\100\DTS\Binn\dts.dll"
This will register 32 bit which is required as SSMS is a 32-bit application.
c:\windows\syswow64\regsvr32 "c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dts.dll"

No comments:

Post a Comment