first set up data source from solution explorer,then new connection from data source from connection managers
directly new ole db connection or ado.net connection etc by right clicking from connection managers
At the end doesn't matter how you created it; the connection manager will work exactly the same. The only diffrence is that with the first approach you only have to create a connection manager once and then can use it in multiple packages.
Rafael Salas
