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
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
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?