You cannot forcibly convert a COM Object of the "system. _ comobject" type into a solution of the class type "system. Data. sqlclient. sqlconnection ".

Error: the COM Object of the type "system. _ comobject" cannot be forcibly converted to the class type "system. Data. sqlclient. sqlconnection ". Indicates that the type instance of the COM component cannot be forcibly converted to the type of the COM component;

 

 

This is actually very simple. This error must have been caused by the use of the script component in SSIs! Why?

Because the script component only supports data from the ADO. net source, you can specify a connection to the server in the Connection Manager.