Keep each script version focused on a single change type (patches for fixes, minors for features, majors for breaking changes). Retain all prior versions and never modify an existing release; copy to ...
The important thing is to get them under version control. Whether you end up using Windows scheduler, SSIS packages, etc is an implementation detail.