I have an ActiveX Script task which accesses an OLE DB Connection object and I want the server name from this conenction object. I am using code DTSGlobalVariables("ServerName").Value = oConn.connectionproperties.item("Server Name") for retrieving name of the server to which a connection object (oConn) is pointing. When I saved the package. Now when I open this package and try to run the ActiveX Step, it fails giving error - "OLE DB property Server Name was not found", when I go to disconnected edit and close the window without making any modifications and try to execute this package, it executes successfully. Why is this happening? When I use "Data Source" instead, it is working fine. Does OLE DB not support 'Server Name' property?if so, why it works when we go to disconnected edit and then execute the step? If the connection is ODBC Driver for SQL server type, can I use 'data source' ?