On Windows Vista running SQL Server 2008 Developer Edition, this package ran fine last month. Now it's giving me the following error: Retrieving the COM class factory for component with CLSID {19E353EF-DAF4-45D8-9A04-FB7F7798DCA7} failed due to the following error: 80040154DB Architect

On Windows Vista running SQL Server 2008 Developer Edition, this package ran fine last month. Now it's giving me the following error: Retrieving the COM class factory for component with CLSID {19E353EF-DAF4-45D8-9A04-FB7F7798DCA7} failed due to the following error: 80040154 DB Architect This class id is for SQLTaskConnectionOleDb Class. Probably the registration is corrupted. Try this: regsvr32 "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\SQLTaskConnections.dll" or on 64bit OS: regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\SQLTaskConnections.dll" Give it a try and let us know how it goes.SSIS Tasks Components Scripts | http://www.cozyroc.com/

It worked. Thanks,Ben Aminnia DB Architect

This solution works. However, whenever I restart my computer this seems to be unregistered once again. Would appreciated it if anyone knows how to correct that.

Thanks! Registering the SQLTaskConnections.dll did the trick!