I am following your instructions on this forum I have created connection manager and connects fine. when I go to advance editor of the datareader the connection manager that I just created does not show on the list. there is one line in the list "lDbconnection ". there is a warring (with yellow icon) says "Not all the connection managers have been set. set all the connection managers" . When I click on refresh button It says "error at data flow task [dataReader source [66]]: Runtime connection manager with Id "" can not be found" How do I set connection mamanger. Or how to fix this issue? appreciate your help.