Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

EXecute Process Task Expand / Collapse
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.

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


Group: General Forum Members
Last Login: Wednesday, May 27, 2015 3:44 AM
Points: 1,865, Visits: 596
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).


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

Add to briefcase

Permissions Expand / Collapse