Hi, I have hit a deadend on this one. Could someone please tell me how can i use the execute process task to run a command which is the statement that i would run using the command prompt but allows me to save the output of the statement that i have run. For example: we retrieve our passwords from a secure database using something like as follows: pwecho <servername> <user_id> this statement when run from the command prompt returns the password for the user_id on that server. I would like to use the SSIS execute process task and save the returned password string into a variable and then save it into a row in a database table. If this works. It woudl replace a very cumbersome process that we have right now for retrieving the secure passwords. please help.

Hi Select the executable file(.exe) and pass the argurment which you have written, then Create a variable and select the variable under standardOutputVariable to hold you result