October 22, 2014 at 12:27 pm
Hi
We have an ssis job that is run using a sql server agent account and it started failing after some patches on the server. The package is file system deployment. I have been told that it runs in 64 bit. But I don't see a 64 bit dtexec.exe on that machine. So does that mean the package is actually running in 32 bit. The job itself doesn't have "Run in 32 bit" checked.
Please suggest.
Thank you,
Veena
October 22, 2014 at 1:30 pm
Yes, dtexec is used behind the scenes.
What are the errors?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 22, 2014 at 3:26 pm
Hi Koen,
Thank you for your quick response.
The errors are due to the fact that the admins upgraded the oracle client from 11 to 12. They say It has been 64 bit client even before the upgrade, but I am leaning more towards installing a 32 bit 12 client. The information you gave is very helpful as I can confirm that it was running in 32 bit even before the upgrade.
October 23, 2014 at 9:24 am
I don't know how you would get a server without the 64 bit utility unless its a 32 bit server. I believe the 64 bit installs by default, and the 32 bit needs to be specially installed.
October 23, 2014 at 9:26 am
Hi,
Actually even after installing the 32 bit client, there is a different error. Does anyone know of problems when installing the Oracle 32 bit and 64 bit clients together? Please suggest
Check DW Status Check DW Status Description: There was an exception while loading Script Task from XML: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications.Core<c/> Version=10.0.0.0<c/> Culture=neutral<c/> PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.VisualStudio.Tools.Applications.Core<c/> Version=10.0.0.0<c/> Culture=neutral<c/> PublicKeyToken=b03f5f7f11d50a3a' at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.<CleanUp>b__1a() at Microsoft.SqlServer.IntegrationServices.VSTA.MtaExecution.Run(Action action) at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.CleanUp() at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.DisposeVstaHelper() at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.MigrateVSTA21ScriptProject(XmlElement elemProj<c/> IDTSInfoEvents events) at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(XmlElement elemProj<c/> IDTSInfoEvents events) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging<c/> set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off<c/> remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. End Error Error: 2014-10-23 10:06:57.78 Code: 0x00000003 Source: Script Task Script Task Description: There was an exception while loading Script Task from XML: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications.Core<c/> Version=10.0.0.0<c/> Culture=neutral<c/> PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.VisualStudio.Tools.Applications.Core<c/> Version=10.0.0.0<c/> Culture=neutral<c/> PublicKeyToken=b03f5f7f11d50a3a' at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.<CleanUp>b__1a() at Microsoft.SqlServer.IntegrationServices.VSTA.MtaExecution.Run(Action action) at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.CleanUp() at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.DisposeVstaHelper() at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.MigrateVSTA21ScriptProject(XmlElement elemProj<c/> IDTSInfoEvents events) at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(XmlElement elemProj<c/> IDTSInfoEvents events) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging<c/> set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off<c/> remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. End Error Error: 2014-10-23 10:06:57.80 Code: 0x00000003 Source: Script Task Script Task Description: There was an exception while loading Script Task from XML: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications.Core<c/> Version=10.0.0.0<c/> Culture=neutral<c/> PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.VisualStudio.Tools.Applications.Core<c/> Version=10.0.0.0<c/> Culture=neutral<c/> PublicKeyToken=b03f5f7f11d50a3a' at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.<CleanUp>b__1a() at Microsoft.SqlServer.IntegrationServices.VSTA.MtaExecution.Run(Action action) at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.CleanUp() at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.Disp... The package execution fa... The step failed.,00:00:01,0,0,,,,0
Thank you,
Veena
October 23, 2014 at 9:34 am
Hi Nevyn,
I used this query to find that it is 64 bit enterprise. But when I remote logged in. I was only able to find a 32 bit dtexec. I am not sure of why only 32 bit dtexec is available though. I still have problems even after installing 32 bit oracle client. I have posted the error in a message before this one.
SELECT SERVERPROPERTY('Edition')
Please let me know if you think of something. I hugely appreciate you alls responses.
October 23, 2014 at 10:59 am
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
October 23, 2014 at 12:01 pm
I am finally able to confirm the problem.
The problem occurs only when connecting to oracle using the script task using the code below. If I connect using an Oracle provider it works fine
Dim cnn As OleDb.OleDbConnection
Dim sConnString As String = Dts.Variables("User::OracleConnectionString").Value.ToString
cnn = New OleDbConnection(sConnString)
Dim cmd As New OleDbCommand
With cmd
.CommandType = CommandType.Text
.CommandText = "SELECT dw_info.get_status(TRUNC(SYSDATE)) STATUS FROM DUAL"
.CommandTimeout = 0
.Connection = cnn
End With
cnn.Open()
October 23, 2014 at 12:15 pm
Nevyn (10/23/2014)
I don't know how you would get a server without the 64 bit utility unless its a 32 bit server. I believe the 64 bit installs by default, and the 32 bit needs to be specially installed.
The 32-bit is installed by default as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply