Execute An SP For Get A Value From A Script Transformation Task For Every Row

HI,
I have a date field like 2008-01-09 15:12:57' and for every row, I
must execute a sql for get a value returned from function in my DB.

I must increaze the fileld belove row.IDgiornoMisurazione for output
in any row.
--------------------------
Script above always have a cast type error....
--------------------------
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Imports System.Data.SqlClient


Public Class ScriptMain
Inherits UserComponent

Dim sqlConn As SqlConnection
Dim strSQL As String
Dim sqlCmd As SqlCommand = New SqlCommand(strSQL)


Public Overrides Sub AcquireConnections(ByVal Transaction As Object)
sqlConn =CType(Connections.ObjConnection.AcquireConnection(Transaction),SqlConnection)
End Sub


Public Overrides Sub PreExecute()
With sqlCmd
.Connection = sqlConn
.CommandTimeout = 30
.CommandType = CommandType.Text
End With
End Sub


Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
strSQL = "SELECT dbo.getIDgiornoMisurazione('" & Row.DateTime & "')"
Row.IDgiornoMisurazione = CInt((sqlCmd.ExecuteScalar()))
End Sub


Public Overrides Sub ReleaseConnections()
If sqlConn IsNot Nothing Then
Connections.ObjConnection.ReleaseConnection(sqlConn)
End If
End Sub


End Class



-----------------
My Err
----------------
Error at Data Flow Task [Script Component [1457]]:
System.InvalidCastException: Unable to cast COM object of type
'System.__ComObject' to class type 'System.Data.SqlClient.SqlConnection'.
Instances of types that represent COM components cannot be cast to types
that do not represent COM components; however they can be cast to interfaces
as long as the underlying COM component supports QueryInterface calls for
the IID of the interface.
at
Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exc
eption e)
at
Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.AcquireConnections(Obje
ct transaction)
at
Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections
(IDTSManagedComponentWrapper90 wrapper, Object transaction)
Error at Data Flow Task [DTS.Pipeline]: component "Script Component"
(1457) failed validation and returned error code 0x80004002.

Error at Data Flow Task [DTS.Pipeline]: One or more component failed
validation.

Error at Data Flow Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)



Alen Italy