none
"Unexpected Termination" while running SSIS packages

    Question

  • Hello,

    I'm getting "unexpected termination" error in my SSIS packages more often.

    This was happenning once for a time before, but now it's almost every day. 

    I'm not running any parallel packages.

    SQL Server 2012 and SSIS 2012 are installed on same x64 bit IBM X5 Blade server.

    I'm running out of ideas what may have caused it.

    Here is a dump file:


    Dump Summary
    ------------
    Dump File: WER1556.tmp.mdmp : E:\Apps\AppCrash\WER1556.tmp.mdmp
    Last Write Time: 2013-04-03 06:26:16
    Process Name: ISServerExec.exe : C:\Program Files\Microsoft SQL Server\110\DTS\Binn\ISServerExec.exe
    Process Architecture: x64
    Exception Code: 0xC0000005
    Exception Information: The thread tried to read from or write to a virtual address for which it does not have the appropriate access.
    Heap Information: Not Present

    System Information
    ------------------
    OS Version: 6.1.7601
    CLR Version(s): 4.0.30319.296

    Modules
    -------
    Module Name Module Path Module Version
    ----------- ----------- --------------
    ISServerExec.exe C:\Program Files\Microsoft SQL Server\110\DTS\Binn\ISServerExec.exe 11.0.2100.60
    ntdll.dll C:\Windows\System32\ntdll.dll 6.1.7601.17725
    mscoree.dll C:\Windows\System32\mscoree.dll 4.0.40305.0
    kernel32.dll C:\Windows\System32\kernel32.dll 6.1.7601.17965
    KERNELBASE.dll C:\Windows\System32\KERNELBASE.dll 6.1.7601.17965
    advapi32.dll C:\Windows\System32\advapi32.dll 6.1.7600.16385
    msvcrt.dll C:\Windows\System32\msvcrt.dll 7.0.7601.17744
    sechost.dll C:\Windows\System32\sechost.dll 6.1.7600.16385
    rpcrt4.dll C:\Windows\System32\rpcrt4.dll 6.1.7601.17514
    mscoreei.dll C:\Windows\Microsoft.NET\Framework64\v4.0.30319\mscoreei.dll 4.0.30319.237
    shlwapi.dll C:\Windows\System32\shlwapi.dll 6.1.7601.17514
    gdi32.dll C:\Windows\System32\gdi32.dll 6.1.7601.17514
    user32.dll C:\Windows\System32\user32.dll 6.1.7601.17514
    lpk.dll C:\Windows\System32\lpk.dll 6.1.7600.16385
    usp10.dll C:\Windows\System32\usp10.dll 1.626.7601.17514
    imm32.dll C:\Windows\System32\imm32.dll 6.1.7600.16385
    msctf.dll C:\Windows\System32\msctf.dll 6.1.7600.16385
    clr.dll C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll 4.0.30319.296
    MSVCR100_CLR0400.dll C:\Windows\System32\MSVCR100_CLR0400.dll 10.0.30319.1
    mscorlib.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\mscorlib\4f52500ab48877b85e71430f4f46670f\mscorlib.ni.dll 4.0.30319.296
    ole32.dll C:\Windows\System32\ole32.dll 6.1.7601.17514
    CRYPTBASE.dll C:\Windows\System32\CRYPTBASE.dll 6.1.7600.16385
    nlssorting.dll C:\Windows\Microsoft.NET\Framework64\v4.0.30319\nlssorting.dll 4.0.30319.296
    cryptsp.dll C:\Windows\System32\cryptsp.dll 6.1.7600.16385
    rsaenh.dll C:\Windows\System32\rsaenh.dll 6.1.7600.16385
    clrjit.dll C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clrjit.dll 4.0.30319.1001
    oleaut32.dll C:\Windows\System32\oleaut32.dll 6.1.7601.17676
    System.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System\a91f32875cb3ba779f1b3ceff1690251\System.ni.dll 4.0.30319.1001
    System.Core.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Core\93864146d7ce552dabb2e9d07fa3a926\System.Core.ni.dll 4.0.30319.233
    msdtssrvrutil.DLL C:\Program Files\Microsoft SQL Server\110\DTS\Binn\msdtssrvrutil.DLL 2011.110.2100.60
    msvcr100.dll C:\Windows\System32\msvcr100.dll 10.0.40219.325
    atl100.dll C:\Windows\System32\atl100.dll 10.0.40219.325
    msvcp100.dll C:\Windows\System32\msvcp100.dll 10.0.40219.325
    version.dll C:\Windows\System32\version.dll 6.1.7600.16385
    psapi.dll C:\Windows\System32\psapi.dll 6.1.7600.16385
    Microsoft.SqlServer.Diagnostics.STrace.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\d3640396cf887cc9a62310149a266896\Microsoft.SqlServer.Diagnostics.STrace.ni.dll 11.0.2100.60
    System.Data.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Data\15e31b723aa04fc3fa8d6f763304028c\System.Data.ni.dll 4.0.30319.245
    System.Data.dll C:\Windows\Microsoft.Net\assembly\GAC_64\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll 4.0.30319.245
    ws2_32.dll C:\Windows\System32\ws2_32.dll 6.1.7601.17514
    nsi.dll C:\Windows\System32\nsi.dll 6.1.7600.16385
    crypt32.dll C:\Windows\System32\crypt32.dll 6.1.7601.17856
    msasn1.dll C:\Windows\System32\msasn1.dll 6.1.7601.17514
    System.Configuration.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Configuration\a43bf29e6d6c959640c70eded05dad1a\System.Configuration.ni.dll 4.0.30319.1
    System.Xml.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Xml\f4afb233f160b8e55aad4660e45b374c\System.Xml.ni.dll 4.0.30319.233
    Microsoft.SqlServer.IntegrationServices.Server.Shared.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\c72df0bf371efa8b94e4abe558c5ea73\Microsoft.SqlServer.IntegrationServices.Server.Shared.ni.dll 11.0.2100.60
    Microsoft.SqlServer.IntegrationServices.Server.dll C:\Program Files\Microsoft SQL Server\110\DTS\Binn\Microsoft.SqlServer.IntegrationServices.Server.dll 11.0.2100.60
    System.Transactions.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Transactions\7b2099a1386e38ff198a51939304ce6e\System.Transactions.ni.dll 4.0.30319.1
    System.Transactions.dll C:\Windows\Microsoft.Net\assembly\GAC_64\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll 4.0.30319.1
    System.EnterpriseServices.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.EnterpriseSe#\daddb5b290adad83e34d87013e8569bc\System.EnterpriseServices.ni.dll 4.0.30319.1
    System.EnterpriseServices.Wrapper.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.EnterpriseSe#\daddb5b290adad83e34d87013e8569bc\System.EnterpriseServices.Wrapper.dll 4.0.30319.1
    System.EnterpriseServices.Wrapper.dll C:\Windows\Microsoft.Net\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll 4.0.30319.1
    RpcRtRemote.dll C:\Windows\System32\RpcRtRemote.dll 6.1.7601.17514
    security.dll C:\Windows\System32\security.dll 6.1.7600.16385
    secur32.dll C:\Windows\System32\secur32.dll 6.1.7601.17725
    sspicli.dll C:\Windows\System32\sspicli.dll 6.1.7601.17725
    credssp.dll C:\Windows\System32\credssp.dll 6.1.7601.17514
    schannel.dll C:\Windows\System32\schannel.dll 6.1.7601.17856
    kerberos.dll C:\Windows\System32\kerberos.dll 6.1.7601.17926
    cryptdll.dll C:\Windows\System32\cryptdll.dll 6.1.7600.16385
    msv1_0.dll C:\Windows\System32\msv1_0.dll 6.1.7601.17514
    ntdsapi.dll C:\Windows\System32\ntdsapi.dll 6.1.7600.16385
    netapi32.dll C:\Windows\System32\netapi32.dll 6.1.7601.17887
    netutils.dll C:\Windows\System32\netutils.dll 6.1.7601.17514
    srvcli.dll C:\Windows\System32\srvcli.dll 6.1.7601.17514
    wkscli.dll C:\Windows\System32\wkscli.dll 6.1.7601.17514
    logoncli.dll C:\Windows\System32\logoncli.dll 6.1.7601.17514
    mswsock.dll C:\Windows\System32\mswsock.dll 6.1.7601.17514
    WSHTCPIP.DLL C:\Windows\System32\WSHTCPIP.DLL 6.1.7600.16385
    wship6.dll C:\Windows\System32\wship6.dll 6.1.7600.16385
    dnsapi.dll C:\Windows\System32\dnsapi.dll 6.1.7601.17570
    IPHLPAPI.DLL C:\Windows\System32\IPHLPAPI.DLL 6.1.7601.17514
    winnsi.dll C:\Windows\System32\winnsi.dll 6.1.7600.16385
    rasadhlp.dll C:\Windows\System32\rasadhlp.dll 6.1.7600.16385
    FWPUCLNT.DLL C:\Windows\System32\FWPUCLNT.DLL 6.1.7600.16385
    ncrypt.dll C:\Windows\System32\ncrypt.dll 6.1.7601.18007
    bcrypt.dll C:\Windows\System32\bcrypt.dll 6.1.7600.16385
    bcryptprimitives.dll C:\Windows\System32\bcryptprimitives.dll 6.1.7601.17514
    Microsoft.SqlServer.ManagedDTS.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\05ee3baea22b56b206202c65b039b73f\Microsoft.SqlServer.ManagedDTS.ni.dll 11.0.2100.60
    WindowsBase.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\WindowsBase\de1ea3cd2bcb0b8e141a895e45e4be09\WindowsBase.ni.dll 4.0.30319.298
    Microsoft.SqlServer.DTSRuntimeWrap.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\b7fc12e7ae8628c526bfd5f143eef0b7\Microsoft.SqlServer.DTSRuntimeWrap.ni.dll 2011.110.2100.60
    clbcatq.dll C:\Windows\System32\clbcatq.dll 2001.12.8530.16385
    DTS.dll C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTS.dll 2011.110.2100.60
    dtsmsg110.dll C:\Program Files\Microsoft SQL Server\110\DTS\Binn\dtsmsg110.dll 2011.110.2100.60
    Microsoft.SqlServer.Msxml6_interop.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\6506b0e4431e75d6f7bf2c12e63410c3\Microsoft.SqlServer.Msxml6_interop.ni.dll 2011.110.2100.60
    msxml6.dll C:\Windows\System32\msxml6.dll 6.30.7601.17988
    instapi110.dll C:\Program Files\Microsoft SQL Server\110\Shared\instapi110.dll 2011.110.2100.60
    Microsoft.SqlServer.ManagedDTS.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\v4.0_11.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll 11.0.2100.60
    Microsoft.SqlServer.DTSRuntimeWrap.dll C:\Windows\Microsoft.Net\assembly\GAC_64\Microsoft.SqlServer.DTSRuntimeWrap\v4.0_11.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.DTSRuntimeWrap.dll 2011.110.2100.60
    System.Xml.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll 4.0.30319.233
    Microsoft.SqlServer.SqlTDiagM.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\7288915c7c1324e372086afc70eb1241\Microsoft.SqlServer.SqlTDiagM.ni.dll 11.0.2100.60
    DtsConn.dll C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DtsConn.dll 2011.110.2100.60
    odbc32.dll C:\Windows\System32\odbc32.dll 6.1.7601.17514
    winhttp.dll C:\Windows\System32\winhttp.dll 6.1.7601.17514
    webio.dll C:\Windows\System32\webio.dll 6.1.7601.17725
    wininet.dll C:\Windows\System32\wininet.dll 8.0.7601.18094
    urlmon.dll C:\Windows\System32\urlmon.dll 8.0.7601.18094
    iertutil.dll C:\Windows\System32\iertutil.dll 8.0.7601.18094
    shell32.dll C:\Windows\System32\shell32.dll 6.1.7601.17859
    odbcint.dll C:\Windows\System32\odbcint.dll 6.1.7600.16385
    sxs.dll C:\Windows\System32\sxs.dll 6.1.7601.17514
    Microsoft.SqlServer.ManagedConnections.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\a1ce1569e77074308d8a5694834b1630\Microsoft.SqlServer.ManagedConnections.ni.dll 11.0.2100.60
    Microsoft.SqlServer.DtsMsg.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\39f81846eb7d29dd19d7762424a5c1da\Microsoft.SqlServer.DtsMsg.ni.dll 11.0.2100.60
    Microsoft.SqlServer.ManagedConnections.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedConnections\v4.0_11.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedConnections.dll 11.0.2100.60
    System.Numerics.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Numerics\a66416296451fe6d2d8a5506ca41b23d\System.Numerics.ni.dll 4.0.30319.1
    CustomMarshalers.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\CustomMarshalers\bd724489e2661220355b744bfbc92db5\CustomMarshalers.ni.dll 4.0.30319.1
    CustomMarshalers.dll C:\Windows\Microsoft.Net\assembly\GAC_64\CustomMarshalers\v4.0_4.0.0.0__b03f5f7f11d50a3a\CustomMarshalers.dll 4.0.30319.1
    DTSLog.dll C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTSLog.dll 2011.110.2100.60
    System.Runtime.Serialization.Formatters.Soap.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Runtime.Seri#\c79d7323e38d906c09917fe1d40b2ad7\System.Runtime.Serialization.Formatters.Soap.ni.dll 4.0.30319.1
    Microsoft.SqlServer.MaintenancePlanTasks.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\5d0373339f529d343880b05030559338\Microsoft.SqlServer.MaintenancePlanTasks.ni.dll 11.0.2100.60
    Microsoft.SqlServer.SQLTask.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\d1ac96dcaf2903394850c897f5f1c586\Microsoft.SqlServer.SQLTask.ni.dll 11.0.2100.60
    Microsoft.SqlServer.SmoExtended.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\23e80356125a54666bb0e6765444ef1d\Microsoft.SqlServer.SmoExtended.ni.dll 11.0.2100.60
    Microsoft.SqlServer.Smo.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\d41a947e095a65cae191f27a03c569ec\Microsoft.SqlServer.Smo.ni.dll 11.0.2100.60
    ExecPackageTask.dll C:\Program Files\Microsoft SQL Server\110\DTS\Binn\ExecPackageTask.dll 2011.110.2100.60
    Microsoft.SqlServer.FileSystemTask.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\46d3f4034df734d9b32707fee8d6e0b6\Microsoft.SqlServer.FileSystemTask.ni.dll 11.0.2100.60
    DTSComExprEval.dll C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTSComExprEval.dll 2011.110.2100.60
    Microsoft.SqlServer.SqlTDiagM.dll C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.SqlTDiagM\11.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.SqlTDiagM.dll 11.0.2100.60
    Microsoft.SqlServer.DTSPipelineWrap.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\2a0bc4b89a1c28bdda920ecfc360d896\Microsoft.SqlServer.DTSPipelineWrap.ni.dll 2011.110.2100.60
    ntmarta.dll C:\Windows\System32\ntmarta.dll 6.1.7600.16385
    Wldap32.dll C:\Windows\System32\Wldap32.dll 6.1.7601.17514
    Microsoft.SqlServer.Management.Sdk.Sfc.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\6d23c541d045c1ecc94c8e35ed25c709\Microsoft.SqlServer.Management.Sdk.Sfc.ni.dll 11.0.2100.60
    Microsoft.SqlServer.ConnectionInfo.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\a7f06880065991f7ddb526675828651c\Microsoft.SqlServer.ConnectionInfo.ni.dll 11.0.2100.60
    sqlboot.dll C:\Program Files\Microsoft SQL Server\110\Shared\sqlboot.dll 2011.110.2100.60
    oledb32.dll C:\Program Files\Common Files\System\Ole DB\oledb32.dll 6.1.7601.17514
    msdart.dll C:\Windows\System32\msdart.dll 6.1.7600.16385
    comctl32.dll C:\Windows\winsxs\amd64_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7601.17514_none_fa396087175ac9ac\comctl32.dll 6.10.7601.17514
    oledb32r.dll C:\Program Files\Common Files\System\Ole DB\oledb32r.dll 6.1.7600.16385
    comsvcs.dll C:\Windows\System32\comsvcs.dll 2001.12.8530.16385
    sqlncli11.dll C:\Windows\System32\sqlncli11.dll 2011.110.2100.60
    comctl32.dll C:\Windows\winsxs\amd64_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.17514_none_a4d6a923711520a9\comctl32.dll 5.82.7601.17514
    comdlg32.dll C:\Windows\System32\comdlg32.dll 6.1.7601.17514
    SQLNCLIR11.RLL C:\Windows\System32\1033\SQLNCLIR11.RLL 2011.110.2100.60
    netbios.dll C:\Windows\System32\netbios.dll 6.1.7600.16385
    clusapi.dll C:\Windows\System32\clusapi.dll 6.1.7601.17514
    resutils.dll C:\Windows\System32\resutils.dll 6.1.7600.16385
    shfolder.dll C:\Windows\System32\shfolder.dll 6.1.7600.16385
    dtsmsg110.rll C:\Program Files\Microsoft SQL Server\110\DTS\Binn\Resources\1033\dtsmsg110.rll 2011.110.2100.60
    Microsoft.SqlServer.SQLTaskConnectionsWrap.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\f41823c78d59a0649cc5a20dff9d57ec\Microsoft.SqlServer.SQLTaskConnectionsWrap.ni.dll 2011.110.2100.60
    Microsoft.SqlServer.BatchParser.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\98728bd2315b7b06f9f7760de949dd39\Microsoft.SqlServer.BatchParser.ni.dll 2011.110.2100.60
    Microsoft.SqlServer.BatchParser.dll C:\Windows\assembly\GAC_64\Microsoft.SqlServer.BatchParser\11.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.BatchParser.dll 2011.110.2100.60
    msvcr80.dll C:\Windows\winsxs\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_88df89932faf0bf6\msvcr80.dll 8.0.50727.4940
    msvcp80.dll C:\Windows\winsxs\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_88df89932faf0bf6\msvcp80.dll 8.0.50727.4940
    msvcm80.dll C:\Windows\winsxs\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_88df89932faf0bf6\msvcm80.dll 8.0.50727.4940
    SQLTaskConnections.dll C:\Program Files\Microsoft SQL Server\110\DTS\Binn\SQLTaskConnections.dll 2011.110.2100.60
    BatchParser.dll C:\Program Files\Microsoft SQL Server\110\DTS\Binn\BatchParser.dll 2011.110.2100.60
    DTSPipeline.dll C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTSPipeline.dll 2011.110.2100.60
    Microsoft.SqlServer.PipelineXML.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\3baf3c7619e1d0dbe8b1bd51bfa43f89\Microsoft.SqlServer.PipelineXML.ni.dll 11.0.2100.60
    TxDataConvert.dll C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\TxDataConvert.dll 2011.110.2100.60
    OleDbDest.dll C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\OleDbDest.dll 2011.110.2100.60
    OleDbSrc.dll C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\OleDbSrc.dll 2011.110.2100.60
    Microsoft.SqlServer.ForEachADOEnumerator.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\0352fd0b46ab3bea06b46f3d9a40eb92\Microsoft.SqlServer.ForEachADOEnumerator.ni.dll 11.0.2100.60
    Microsoft.SqlServer.ExpressionTask.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\ac2f75f2cabfcc1bf20e8058f6109d23\Microsoft.SqlServer.ExpressionTask.ni.dll 11.0.2100.60
    Microsoft.SqlServer.DTSUtilities.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\c1894df5b331cba0c6c1ce36e277f7ea\Microsoft.SqlServer.DTSUtilities.ni.dll 11.0.2100.60
    Microsoft.SqlServer.ScriptTask.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\4e37fe1c9949e9b8f2441e04ced70fe3\Microsoft.SqlServer.ScriptTask.ni.dll 11.0.2100.60
    Microsoft.SqlServer.VSTAScriptingLib.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\a9d8c987b17c56e2a019dc2f4e2a2826\Microsoft.SqlServer.VSTAScriptingLib.ni.dll 11.0.2100.60
    Microsoft.SqlServer.SendMailTask.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\c8e726f15619bf1acdcf752205b91329\Microsoft.SqlServer.SendMailTask.ni.dll 11.0.2100.60
    Microsoft.SqlServer.PipelineHost.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\6e2f861bb2d0fd20a326c5fae49b1f4b\Microsoft.SqlServer.PipelineHost.ni.dll 11.0.2100.60
    msadce.dll C:\Program Files\Common Files\System\msadc\msadce.dll 6.1.7601.17514
    msadcer.dll C:\Program Files\Common Files\System\msadc\msadcer.dll 6.1.7600.16385
    msado15.dll C:\Program Files\Common Files\System\ado\msado15.dll 6.1.7601.17857
    System.Drawing.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Drawing\5ae853f556290da9399b15b3619f7e15\System.Drawing.ni.dll 4.0.30319.1001
    System.Windows.Forms.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Windows.Forms\f9431bf033456c0374bf3d042eafa097\System.Windows.Forms.ni.dll 4.0.30319.1002
    OraOLEDB11.DLL C:\Oracle\product\11.2.0\client_1\BIN\OraOLEDB11.DLL 11.2.0.1
    OraOLEDBgmr11.dll C:\Oracle\product\11.2.0\client_1\BIN\OraOLEDBgmr11.dll 11.2.0.1
    oci.dll C:\Oracle\product\11.2.0\client_1\BIN\oci.dll 11.2.0.1
    OraOLEDBrst11.dll C:\Oracle\product\11.2.0\client_1\BIN\OraOLEDBrst11.dll 11.2.0.1
    OraOLEDButl11.dll C:\Oracle\product\11.2.0\client_1\BIN\OraOLEDButl11.dll 11.2.0.1
    OraClient11.Dll C:\Oracle\product\11.2.0\client_1\BIN\OraClient11.Dll 11.2.0.1
    oracore11.dll C:\Oracle\product\11.2.0\client_1\BIN\oracore11.dll 11.2.0.1
    oranls11.dll C:\Oracle\product\11.2.0\client_1\BIN\oranls11.dll 11.1.0.6
    oraunls11.dll C:\Oracle\product\11.2.0\client_1\BIN\oraunls11.dll 11.1.0.6
    orauts.dll C:\Oracle\product\11.2.0\client_1\BIN\orauts.dll 11.2.0.1
    winmm.dll C:\Windows\System32\winmm.dll 6.1.7600.16385
    oracommon11.dll C:\Oracle\product\11.2.0\client_1\BIN\oracommon11.dll 11.2.0.1
    orasnls11.dll C:\Oracle\product\11.2.0\client_1\BIN\orasnls11.dll 11.1.0.6
    orageneric11.dll C:\Oracle\product\11.2.0\client_1\BIN\orageneric11.dll 11.2.0.1
    oraxml11.dll C:\Oracle\product\11.2.0\client_1\BIN\oraxml11.dll 11.1.0.6
    oran11.dll C:\Oracle\product\11.2.0\client_1\BIN\oran11.dll 11.2.0.1
    oranl11.dll C:\Oracle\product\11.2.0\client_1\BIN\oranl11.dll 11.2.0.1
    orantcp11.dll C:\Oracle\product\11.2.0\client_1\BIN\orantcp11.dll 11.2.0.1
    oranldap11.dll C:\Oracle\product\11.2.0\client_1\BIN\oranldap11.dll 11.2.0.1
    orannzsbb11.dll C:\Oracle\product\11.2.0\client_1\BIN\orannzsbb11.dll 11.0.0.1
    wsock32.dll C:\Windows\System32\wsock32.dll 6.1.7600.16385
    oraldapclnt11.dll C:\Oracle\product\11.2.0\client_1\BIN\oraldapclnt11.dll 10.1.4.0
    orancrypt11.dll C:\Oracle\product\11.2.0\client_1\BIN\orancrypt11.dll 11.2.0.1
    orazt11.dll C:\Oracle\product\11.2.0\client_1\BIN\orazt11.dll 11.1.0.1
    oranro11.dll C:\Oracle\product\11.2.0\client_1\BIN\oranro11.dll 11.2.0.1
    oranhost11.dll C:\Oracle\product\11.2.0\client_1\BIN\oranhost11.dll 11.2.0.1
    orancds11.dll C:\Oracle\product\11.2.0\client_1\BIN\orancds11.dll 11.2.0.1
    orantns11.dll C:\Oracle\product\11.2.0\client_1\BIN\orantns11.dll 11.2.0.1
    oraztkg11.dll C:\Oracle\product\11.2.0\client_1\BIN\oraztkg11.dll 11.1.0.1
    orapls11.dll C:\Oracle\product\11.2.0\client_1\BIN\orapls11.dll 11.1.0.6
    oraslax11.dll C:\Oracle\product\11.2.0\client_1\BIN\oraslax11.dll 11.1.0.6
    oravsn11.dll C:\Oracle\product\11.2.0\client_1\BIN\oravsn11.dll 11.2.0.1
    oraplp11.dll C:\Oracle\product\11.2.0\client_1\BIN\oraplp11.dll 11.1.0.6
    orahasgen11.dll C:\Oracle\product\11.2.0\client_1\BIN\orahasgen11.dll 11.2.0.1
    samcli.dll C:\Windows\System32\samcli.dll 6.1.7601.17514
    oraocr11.dll C:\Oracle\product\11.2.0\client_1\BIN\oraocr11.dll 11.2.0.1
    oraocrb11.dll C:\Oracle\product\11.2.0\client_1\BIN\oraocrb11.dll 11.2.0.1
    oraocrutl11.dll C:\Oracle\product\11.2.0\client_1\BIN\oraocrutl11.dll 11.2.0.1
    imagehlp.dll C:\Windows\System32\imagehlp.dll 6.1.7601.17787
    oracell11.dll C:\Oracle\product\11.2.0\client_1\BIN\oracell11.dll 11.1.0.6
    orasql11.dll C:\Oracle\product\11.2.0\client_1\BIN\orasql11.dll 11.1.0.6
    oraplc11.dll C:\Oracle\product\11.2.0\client_1\BIN\oraplc11.dll 11.1.0.6
    OraOLEDB11us.dll C:\Oracle\product\11.2.0\client_1\BIN\OraOLEDB11us.dll 11.2.0.1
    OraOLEDBpus11.dll C:\Oracle\product\11.2.0\client_1\BIN\OraOLEDBpus11.dll 11.2.0.1
    System.Windows.Forms.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll 4.0.30319.1002
    nlaapi.dll C:\Windows\System32\nlaapi.dll 6.1.7601.17514
    NapiNSP.dll C:\Windows\System32\NapiNSP.dll 6.1.7600.16385
    winrnr.dll C:\Windows\System32\winrnr.dll 6.1.7600.16385
    cscapi.dll C:\Windows\System32\cscapi.dll 6.1.7601.17514
    TxDerived.dll C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\TxDerived.dll 2011.110.2100.60
    ForEachFileEnumerator.dll C:\Program Files\Microsoft SQL Server\110\DTS\ForEachEnumerators\ForEachFileEnumerator.dll 2011.110.2100.60
    Microsoft.SqlServer.ExecProcTask.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\0c10f687211a7ffcd1553dfb87610c25\Microsoft.SqlServer.ExecProcTask.ni.dll 11.0.2100.60
    Microsoft.SqlServer.PipelineHost.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.SqlServer.PipelineHost\v4.0_11.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.PipelineHost.dll 11.0.2100.60
    Microsoft.SqlServer.TxScript.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.SqlServer#\79f721b5ba9e78dafff563d4e932ce3d\Microsoft.SqlServer.TxScript.ni.dll 11.0.2100.60
    ifxoledbc.dll C:\Program Files\IBM Informix Client SDK\bin\ifxoledbc.dll 3.70.0.14669
    igo4n304.dll C:\Program Files\IBM Informix Client SDK\bin\igo4n304.dll 5.0.0.5
    igl4n304.dll C:\Program Files\IBM Informix Client SDK\bin\igl4n304.dll 5.0.0.5
    msvcr90.dll C:\Windows\winsxs\amd64_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4940_none_08e4299fa83d7e3c\msvcr90.dll 9.0.30729.4940
    IfmxConn.dll C:\Program Files\IBM Informix Client SDK\bin\IfmxConn.dll 0.0.0.0
    iregt07b.dll C:\Program Files\IBM Informix Client SDK\bin\iregt07b.dll 3.70.0.14669
    irrgt09a.dll C:\Program Files\IBM Informix Client SDK\bin\irrgt09a.dll 3.70.0.14669
    isqlt09a.dll C:\Program Files\IBM Informix Client SDK\bin\isqlt09a.dll 3.70.0.14669
    TxUnionAll.dll C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\TxUnionAll.dll 2011.110.2100.60
    profapi.dll C:\Windows\System32\profapi.dll 6.1.7600.16385
    normaliz.dll C:\Windows\System32\normaliz.dll 6.1.7600.16385
    rasapi32.dll C:\Windows\System32\rasapi32.dll 6.1.7600.16385
    rasman.dll C:\Windows\System32\rasman.dll 6.1.7600.16385
    rtutils.dll C:\Windows\System32\rtutils.dll 6.1.7601.17514
    SensApi.dll C:\Windows\System32\SensApi.dll 6.1.7600.16385
    System.Web.ni.dll C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Web\166341eedd090f3bf39be959ddcfde77\System.Web.ni.dll 4.0.30319.272
    dhcpcsvc6.DLL C:\Windows\System32\dhcpcsvc6.DLL 6.1.7600.16385
    dhcpcsvc.dll C:\Windows\System32\dhcpcsvc.dll 6.1.7600.16385
    CommandDest.dll C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\CommandDest.dll 2011.110.2100.60
    TxSplit.dll C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\TxSplit.dll 2011.110.2100.60
    TxLookup.dll C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\TxLookup.dll 2011.110.2100.60
    TxRowCount.dll C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\TxRowCount.dll 2011.110.2100.60
    TxCache.dll C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\TxCache.dll 2011.110.2100.60
    TxMulticast.dll C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\TxMulticast.dll 2011.110.2100.60


    Maciej

    Wednesday, April 03, 2013 6:59 AM

Answers

  • Hello,

    After a while I have found a solution.

    It was because sql server agent service account didn't have sufficient permissions.

    Problem still is, that no one knows what kind of permissions are exactly required.

    We ended up giving server administrator to sql agent service account.

    Since then problem disappeared.

    Regards


    Maciej

    Wednesday, May 08, 2013 12:17 PM

All replies

  • Exception Information: The thread tried to read from or write to a virtual address for which it does not have the appropriate access.

    Can you check whether the thread has appropriate permission , i mean the appropriate permission for package to execute or access to Virtual Address

    Wednesday, April 03, 2013 7:14 AM
  • Package is failing when running under SQL Agent service account.

    Could you tell me more specific how should I verify this?

    Should I apply any particular SSIS role for sql agent service account?


    Maciej


    Wednesday, April 03, 2013 7:41 AM
  • Make sure that the SL Agent service account has read/write permission to the files used in the package.

    Nitesh Rai- Please mark the post as answered if it answers your question

    Wednesday, April 03, 2013 8:14 AM
  • Thing is that packages that are failing are not using any files.

    There are pure SQL data transfers. 

    SQL Agent sevice account has sysadmin role, so I'm not sure what else can be applied.

    Maybe there is some policy, or server setting that should be applied to sql agent account?

    Also I have a suspicion on BufferTempStorage setting.


    Regards


    Maciej

    Wednesday, April 03, 2013 8:27 AM
  • You can try changing this to a valid file path. In fact this property should be made configurable in addiiton to BLOBTempstoragepath.

    Nitesh Rai- Please mark the post as answered if it answers your question

    Wednesday, April 03, 2013 8:32 AM
  • I will change that, but what's the chance that this is causing the error?

    Maciej

    Wednesday, April 03, 2013 9:14 AM
  • I will change that, but what's the chance that this is causing the error?

    Not sure; but that will eliminate this factor causing the error (if it is not the cause of error)

    Nitesh Rai- Please mark the post as answered if it answers your question

    Wednesday, April 03, 2013 9:17 AM
  • Hi Maciej,

    The issue might be related to the Visual Studio not the SQL Server Integration Services. You can try the following command lines to check if it a Visual Studio issue:

    devenv.exe /ResetSettings
    This will reset the Visual Studio settings to the defaults and maybe help you solve the problem.

    devenv.exe /ResetSkipPkgs
    If you've had a Package Load Failure, running devenv.exe with the /ResetSkipPkgs flag will re-enable those failed packages and will try loading them again.

    devenv.exe /ResetUserData

    devenv.exe /SafeMode

    References:

    Regards,


    Mike Yin
    TechNet Community Support

    Friday, April 05, 2013 7:01 AM
    Moderator
  • Hello,

    After a while I have found a solution.

    It was because sql server agent service account didn't have sufficient permissions.

    Problem still is, that no one knows what kind of permissions are exactly required.

    We ended up giving server administrator to sql agent service account.

    Since then problem disappeared.

    Regards


    Maciej

    Wednesday, May 08, 2013 12:17 PM