Hi All, I have OLEDB command as my desination with ADO.Net connection manager, I want to pass parameters from oledb command, Please can any body help me how to pass parameters when using ADO.net conn manager. Thanks in Advance. RH sql

you CAN NOT user ado.net connection manager in oledb command! you should use OLEDB Connection manager there. and for that, you put your sql statement in the component properties tab in the sql command property, like this: update table1 set field1=? where id=? the question marks are parameter markers, then in column mappings tab, you can map input columns from data stream to the command parametershttp://www.rad.pasfu.com

Sorry I forgot to tell, I want to pass parameters for a stored proc in oledb command using ado.net conn manager. Thanks!sql

Sorry I forgot to tell, I want to pass parameters for a stored proc in oledb command using ado.net conn manager. Thanks! sql could you explain this part more? I'm not clear with your requesthttp://www.rad.pasfu.com

I have OLEDB command as my desination with ADO.Net connection manager, I want to pass input parameters to a stored proc in oledb command using ado.net conn manager. Thanks! sql

I have OLEDB command as my desination with ADO.Net connection manager, I want to pass input parameters to a stored proc in oledb command using ado.net conn manager. Thanks! sql But you can not use ado.net connection managers in OLEDB Command as I told you in my first post. you should use OLEDB Connection managers. where is the source of your stored procedure? is it sql server? if yes, you can create an oledb connection manager simply and use it inside oledb command.http://www.rad.pasfu.com

Thanks got it.sql