MagnusN
Posts: 1
Joined: Fri Apr 09, 2010 6:57 pm
Location: Sweden

SSIS VB.Net DTS ScriptTask exception

Thu Jun 10, 2010 6:13 pm

I have a solution in SSIS Visual Studio 2005.

In one object we have a VB script to convert coordinates to WGS84.
When running this I get Runtime error
"DTS Script Task has encountered an exception in user code: Project name; ScriptTask_xxx Object reference not set to an instance of an object."

Assemblies GPSTools are installed in GAC and C++ 2005 Redistributable is installed.

I changed the connection to right server:
"Private Function DataBaseInstance() As SqlConnection
Dim res As SqlConnection
Try
res = (DirectCast(Dts.Connections("12333.Or_Offline.adm").AcquireConnection(Dts.Transaction), SqlClient.SqlConnection))
If res.State = ConnectionState.Open Then res.Close()
Catch ex As Exception
res = Nothing
End Try
Return res
End Function
End Class"

This has been working before but have been moved to another server so probably it has lost the connection.

Something is missing or not setup correctly? Googled a lot on this on SQL server sites,Integration services but couldn't find similar problem.

Do anyone have experiences of this issue?

Regards Magnus

Return to “GpsTools”