The important thing is to get them under version control. Whether you end up using Windows scheduler, SSIS packages, etc is an implementation detail.