ActiveX script task issues in SQL 2008
Hi,
I have a SSIS packages which I've developed on SQL 2005 (SP2) which contains a number of ActiveX script task objects and it runs successfully on SQL Server 2005. When I tested the same SSIS package on SQL Server 2008 (June CTP) all the ActiveX scipt tasks fails without any great details being sent to the output window.
One of these ActiveX scipts contains the following code :
Function Main()
strComputer = DTSGlobalVariables("ServerName").Value
Set objWMIService = GetObject _
("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * From Win32_NetworkAdapterConfiguration Where IPEnabled = True")
For Each objItem in colItems
' msgbox "Caption: " & objItem.Caption
For Each objAddress in objItem.IPAddress
objAddresses = objAddresses + objAddress +"; "
Next
Next
'msgbox "address: " & objAddresses
DTSGlobalVariables("ServerIPAddress").Value = objAddresses
End Function
Thanks
