<div>
I ended up using %G for my param, but it worked like a charm. &nbsp;I thought I would have to write some C# code, but it didn't occur to me to use ECHO instead of FIND (as you know find places lines in your file and doesn't really work right anyway for this). &nbsp;Also the for loop was great. &nbsp;Thanks a lot for this response, it was just what the doctor ordered.<br />

</div>


I ended up using %G for my param, but it worked like a charm.  I thought I would have to write some C# code, but it didn't occur to me to use ECHO instead of FIND (as you know find places lines in your file and doesn't really work right anyway for this).  Also the for loop was great.  Thanks a lot for this response, it was just what the doctor ordered.


<div>
:-)<br />
Glad I could be of any help !
</div>


<div>
<div class="content wysiwyg-content">
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. &nbsp;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. &nbsp;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. &nbsp;Having the initial data file simply not include those lines is not an option. <br />
<br />
I am using SQLserver2005
</div>
</div>


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

Unexpected end of file with bulk insert

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.