none
How i can pass parameters to Ado.Net Source ?

    Question

  • Hi All ,

    I have Ado.net source inside data flow task that runs inside For each loop container , how i can pass parameter that i get in for each loop to Ado.net source.

    Regards , Evgeniy.

    Sunday, October 13, 2013 1:13 PM

Answers

  • hi

    data flow -->property Expressions editor--ado net source sql command 

    after that you write your command 

    bye

    • Marked as answer by Evgeniy.co.il Monday, October 14, 2013 6:33 AM
    Sunday, October 13, 2013 6:17 PM

All replies

  • Go to connection manager for ADO .NET Source and you've expression builder available in properties window for it through which you can set an expression to use your parameter from for each loop.
    Sunday, October 13, 2013 6:00 PM
  • hi

    data flow -->property Expressions editor--ado net source sql command 

    after that you write your command 

    bye

    • Marked as answer by Evgeniy.co.il Monday, October 14, 2013 6:33 AM
    Sunday, October 13, 2013 6:17 PM
  • Thanx mhm_2004de , thanx Visakh16 ,

    it works

    Just interesting is there any other solution for this purpose,

    Regards , Evgeniy.

    Monday, October 14, 2013 6:39 AM