In SQL server I am receiving a data file with blank lines at the end of it, I'm not sure if there is a way with a bulk insert to ignore those lines. Adding at the last column to end with a /r/n only causes it to have an unexpected end of file error due to those blank lines. I need if possible, a solution on how to either get rid of those blank lines with a relatively simple dos script or to make bulk insert ignore them. Having the initial data file simply not include those lines is not an option.
I am using SQLserver2005