How do I load this SAS text file to SQL Server 2005
I would write a python script that would, 


parse the columns descriptor file, get their widths and names
iterate over all the data in the input file, splitting out the data into variables
construct a sql query with these variables to the sql server with SQLAlchemy to be sent one by one or as a batch of rows or 1000 at a time


This script would take the columns descriptor file and the data file. The script would also have a database config file containing the database connection string or you can pass that as a third parameter.

I would write this for you, but I don't have time right now. This is a neat problem to solve. Python is perfect for this however. I wish my SAS problem was so easy.