I am working on the SSIS package only to copy data from a remote server to a local database. A ubiquitous connection is used for the data source, and the destination is OLE DB.
However, it raises this error as soon as I open the package from Solution Explorer:
I did research and ran regsvr32 "C:\Program Files\Microsoft SQL Server\110\DTS\Binn\dts.dll"cmd on the command line as an administrator. But this does not solve the problem, although the team succeeded.
This can sometimes hurt if I restart SQL Server Data Tools (visual studio 2010). Nevertheless, I would be grateful if someone could find a real reason and solve it forever.
Thanks in advance!