SQLTeam.com | Weblogs | Forums

Issue with Bulk command

I am importing a txt file into an empty sql table. This works fine using the Bulk command.

However, there are some empty rows in the input text file, which causes a fatal error in my stored procedure.

Is there a way by which theses empty rows can bypass the Insert?

This is one big struggle for me. I have many many stored procedures

Is the text file fixed width or delimited?