Hi, I want to execute unix scripts which execute oracle stored procedure. How can i execute Unix script in ssis.Please let me know the steps. Is it possible to pass the values to Unix script from SSIS? Has anybody tried this before? Please let me know. Thanks, Vaibhav

I think you cannot. SSIS hasn't any task to support unix scripts.http://www.rad.pasfu.com

Vaibhav, Assuming you executing UNIX scripts for STORED PROC execution and as Reza said SSIS dosnt have any functioanlity to execute Unix script right through in SSIS, In that case for executing Oracle stored proc you can use Excute SQL task by creating connection with Oracle server where you can pass values to STORED Procedure. Another approch would be, 1) but if you have avaibility of bridge software which executes UNIX scripts on Windows machine is MKS Toolkit (As I know which is not free). 2) Create Batch file to call MKS Toolkit with SP execution command. 3) Use Execute process task to run batch file. Hope this will help! Thanks! CPatil MCTS 2008 & 2005 , MCITP 2008 -- Please remember to mark the post as answered if it answers your question.