There seems to be a different problem than the oracle drivers.

I made the package simpler by just using one simple script task. And used in the job with files system deployment. My job takes for ever. Is there anything wrong with this script. Please let me know if you have any suggestions.

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

<System.AddIn.AddIn("ScriptMain", Version:="1.0", Publisher:="", Description:="")> _

<System.CLSCompliantAttribute(False)> _

Partial Public Class ScriptMain

Inherits Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase

Public Sub Main()

Dts.TaskResult = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success

End Sub

End Class