Creating an instance of the COM component with CLSID error
December 13th, 2011
No comments
Ever had this really annoying error pop up when you are trying to view or edit a step within a Job? It happened to me again today.
I found a nice simple fix in the end.
Open up the command line tool Navigate to your Microsoft SQL Server\100\DTS\binn folder. From there run regsvr32 dts.dll
You should get a popup stating “DLLReigsterServer in dts.dll succeeded.” You’ll then need to restart Management Studio.