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