Hi All, We are trying to use .Net providers for OLEDB/ oracle provider for OLEDB to extract data from oracle server. And we wanted to use parameters or variables to construct the query so that we can load only selective data depending on the parameter values. However, ADO.Net DataFlow source has only 2 Data Access Mode - Table or View and SQL Command [with no option to pass parameters]. Can you please advise, how should I go about configuring this DFT source ? Please let me know, if you need any more inputs on this.

Isn't there a property you can override with an expression? If it's not available on the source then it's probably an expression on the data flow itself. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Yes as Joost suggested you need to set SQL Command using Expression on DFT see this thread for detailed steps http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/85321ecf-d7a4-45eb-9202-0645dbace895/Shailesh , Please mark the post as answered if it answers your question.