Attempting to import a csv into SQL Server that is lead by a random number of 0
===

Basically, I want to skip the random number of zeroes. The solution, I think, would be to create a dummy column, in the format file, that ends on the first nonzero value. However, after scouring the net, I have no idea how to do that.