Unable to change service plan in SSMS

Question

I have several maintenance plans on my standard installation of SQL Server 2008 Service Pack 1 (SP1). I run SQL Server Management Studio on both my development machine and its copy on the server. In any case, if I try to change any of the existing maintenance plans or select "New maintenance plan ...", nothing happens.

The only solution I saw for this was in this thread , which suggested updating your installation to include "Management Tools Complete" instead of Basic, but this option is not available on my installation screen. I assume this is because I am launching Standard, not Enterprise. Please note that this function is used to work, so I know that this is not a limitation of Standard Edition. I can’t say for sure when it stops working, but I believe that the last time I used it was before SP1.

Answer 1

, , . , , Microsoft DTS (post sql 2000).

, , , SSIS ( ).

Answer 2

0

, ....

. C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\JOBS

. , . ( ), SQL Manager.

: ( Windows 2012 R2 SQL 2014 )

Νικοσ Γιαννιοσ

Answer 3

. , Management Studio, SQL Server, dts.dll. , , .

• .
• CMD regsvr32 dts.dll. Binn CD C:\Program Files\Microsoft SQL Server\120\DTS\Binn, exec regsvr32 dts.dll NB. , < 120\DTS\Binn > SQL Server 2014 100\DTS\Binn 110\DTS\Binn SQL Server 2008 2012 ,
• , . : servername.domainname.local\instancename, portnumber