Skip to Content
0
Former Member
Aug 06, 2010 at 10:47 PM

Failed to load SSIS task - Logic Task 2008

828 Views

Hi,

<p>

I'm running a Custom SSIS package that uses the BPC Logic 2008 task. I'm running this on a dual server-BPC 7M environment(SQL 2008 on 64-bit DB server). It works successfully when I execute it from within Visual Studio 2008 on the Application server and also works successfully when I call the SSIS package from a *.bat file on the Application server. I need to call the SSIS package from a stored procedure. But when I call the SSIS package directly from a stored procedure or I try calling the *.bat file(that calls the SSIS Package) from a stored procedure, I get the following error:

<p>

Microsoft (R) SQL Server Execute Package Utility

Version 10.0.2531.0 for 32-bit

Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

NULL

Started: 5:14:52 PM

Error: 2010-08-06 17:14:53.75

Code: 0xC0010018

Source: Logic Task 2008

Description: Failed to load task "Logic Task 2008", type

"OSoft.Services.Application.DataMgr.Task.SSISTaskLogic, OSoftTaskLogic2008, Version=7.0.112.0,

Culture=neutral, PublicKeyToken=bf6c37fa78f5a648". The contact information for this task is "".

End Error

Error: 2010-08-06 17:14:53.82

Code: 0xC0010026

Source: Logic Task 2008

Description: The task has failed to load. The contact information for this task is "".

End Error

Error: 2010-08-06 17:14:53.82

Code: 0xC0024107

Source: Logic Task 2008

Description: There were errors during task validation.

End Error

Error: 2010-08-06 17:14:53.82

Code: 0xC0010025

Source: RunAllocations

Description: The package cannot execute because it contains tasks that failed to load.

End Error

DTExec: The package execution returned DTSER_FAILURE (1).

Started: 5:14:52 PM

Finished: 5:14:53 PM

Elapsed: 0.984 seconds

NULL

<p>

Here's my code to call the *.dtsx file from a stored procedure:

EXEC master..xp_cmdshell 'C:\dtexec.exe /file "
AppServer\Osoft\Webfolders\Appset_Name\Finance\DataManager\PackageFiles\RunAllocations.dtsx "'

<p>

And hereu2019s my code to call the *.bat file from a stored procedure:

EXEC master.dbo.xp_cmdshell '
AppServer\Osoft\Webfolders\Appset_Name\Finance\DataManager\SelectionFiles\RunAllocationsFileSystem.bat'

<p>

Any help would be greatly appreciated - thanks,

<p>

Glenn

Edited by: Glenn Van Der Werff on Aug 9, 2010 12:05 PM