It depends on what you want to do. Execute SQL Task is generally not used to return a result set. I usually use it for updates, deletes, etc....

I agree with the other comments if you have the time and desire to build a data warehouse. It is a big task if you are trying to learn...