HI

I am trying to connect to a sql server to execute a SSIS package (a maintenanceplan)

I am getting an exception indicating there might miss an assembly.

Debug path: C:\Program Files (x86)\VisualCron\MSSQL2008\ssis_debug.txt
Running as: NT AUTHORITY\SYSTEM
Arg. count: 1
Deserializing
After deserializing
Deleting file
File deleted
Setting SQL Credential
Executing package
In executing package

Unhandled error occured: System.BadImageFormatException: Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.
File name: 'Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
at Microsoft.SqlServer.Dts.Runtime.Application..ctor()
at SSISExecute2008.SSIS2008.ExecutePackage(TaskSSISInfoClass task)
at Yhm4hhoYdxbTZ3Orpu.louSCaa5k8JXEEU08B.IrdORY5ou(String[] )

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, 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, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Please advice.

Regards
/Klaus

Seems like you need to switch the architecture flag from 32 to 64 bit or the other way in the Task settings.

---

Hi
Thanks now it is acting different... Next exception - wonder if the fail occurs on the sqlserver or on visual cron:

Unhandled error occured: Microsoft.SqlServer.Dts.Runtime.DtsComException: An Integration Services class cannot be found. Make sure that Integration Services is correctly installed on the computer that is running the application. Also, make sure that the 64-bit version of Integration Services is installed if you are running a 64-bit application. ---> System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {BA785E28-3D7B-47AE-A4F9-4784F61B598A} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
at Microsoft.SqlServer.Dts.Runtime.Application..ctor()
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.Application..ctor()
at SSISExecute2008.SSIS2008.ExecutePackage(TaskSSISInfoClass task)
at Yhm4hhoYdxbTZ3Orpu.louSCaa5k8JXEEU08B.IrdORY5ou(String[] )

Sounds like Integration services have not been installed at the VC server. Or you are not using MSSQL 2008.

---