Hello all!
I am writing a BULK INSERT statement that loads a variable length file that I receive daily. However, the last lines of this file contain a few lines of HTML that is causing the BULK INSERT to fail. Is there a way I can have BULK INSERT load all records and stop when it sees a certain string. Or, is there anyway to strip these few lines out of the file automatically?
The section that is causing it to fail looks like this:
<br>
<h3>Summary:</h3>
<table border=1 cellspacing=0 cellpadding=2>
</table>
<br><b>Total Successful</b><br>
Any ideas are greatly appreciated!
Thank you!
-MK
I am writing a BULK INSERT statement that loads a variable length file that I receive daily. However, the last lines of this file contain a few lines of HTML that is causing the BULK INSERT to fail. Is there a way I can have BULK INSERT load all records and stop when it sees a certain string. Or, is there anyway to strip these few lines out of the file automatically?
The section that is causing it to fail looks like this:
<br>
<h3>Summary:</h3>
<table border=1 cellspacing=0 cellpadding=2>
</table>
<br><b>Total Successful</b><br>
Any ideas are greatly appreciated!
Thank you!
-MK