UnderSeven
asked on
Unexpected end of file with bulk insert
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
I am using SQLserver2005
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
:-)
Glad I could be of any help !
Glad I could be of any help !
ASKER