Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

EXecute Process Task Expand / Collapse
Author
Message
Posted Friday, July 25, 2008 12:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 8:43 AM
Points: 1, Visits: 16
Hi Folks,
I am facing this problem with the Execute Process task. I am executing a C# parser exe file to convert .xls into .csv and passing below as the arguments.
Executable:C:\AIProjects\SourceCode\Trunk\Src\App\ETL\Utilities\CreditSuisse.Aiop.Etl.Utilities.WSOCashAvailableFileParser\obj\Release\CreditSuisse.Aiop.Etl.Utilities.WSOCashAvailableFileParser.exe

Arguments:"C:\Personal\Visual Studio 2005\Projects\AIOP\ETL\Sources\XLS File\7-24-08.xls" "C:\Personal\Visual Studio 2005\Projects\AIOP\ETL\Sources\WSO\CashAvailable\abcde.csv"


This is the error it is throwing up:

[Execute Process Task] Error: In Executing "C:\AIProjects\SourceCode\Trunk\Src\App\ETL\Utilities\CreditSuisse.Aiop.Etl.Utilities.WSOCashAvailableFileParser\obj\Release\CreditSuisse.Aiop.Etl.Utilities.WSOCashAvailableFileParser.exe" ""C:\Personal\Visual Studio 2005\Projects\AIOP\ETL\Sources\XLS File\7-24-08.xls" "C:\Personal\Visual Studio 2005\Projects\AIOP\ETL\Sources\WSO\CashAvailable\abcde.csv"" at "", The process exit code was "-532459699" while the expected was "0".


The c# parser is working fine when i execute it separetly but if i tend to call it through execute package, it throws an error!!!

Can somebody Help Me with this!!!!!! Thanks!!!!

Post #541233
Posted Monday, July 28, 2008 4:35 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:39 AM
Points: 1,865, Visits: 593
Could you not use a data flow task with the excel file as the source and the csv file as the destination? It would be easier to debug where any errors may be occuring (using data viewers, for example).

Tom


Life: it twists and turns like a twisty turny thing
Post #541740
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse