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