Object doesn't support this property or method : 'DTSGlobalVariables(...).Value.Open
It's missing a Set...
Function Main()
Set DTSGlobalVariables("adoConnection").Value= CreateObject ("ADODB.Recordset")
DTSGlobalVariables("adoConnection").Value.open strsql, "DRIVER={SQL
Server};Server=DUBLIN;UID=sa;PWD=;Database=AktieTool"
end function
--
Michael Harris
Microsoft.MVP.Scripting
--
Quote:
> I created an activeX Script Task in a DTS, from SQL 7, with this VB script
> code :
> Function Main()
> DTSGlobalVariables("adoConnection").Value= CreateObject ("ADODB.Recordset")
> DTSGlobalVariables("adoConnection").Value.open strsql, "DRIVER={SQL
> Server};Server=DUBLIN;UID=sa;PWD=;Database=AktieTool"
> end function
> And I received this error message :
> Have you an idea to resolve this problem ?
> Thank you very much .
