Fix: Easy fix is to apply the service pack 1. However, if any reason you can’t apply the sevice pack you will need to apply this:
- Run cmd
- cd C:\Program Files (x86)\Microsoft SQL Server\100\DTS\binn
- REGSVR32.EXE dts.dll
- Notice the success message.
.
------------------------------------------------------------------------------------------------------------