SQL server will allow zero-length strings without issue, as long as your datatype supports it. Just assign the string value of ('') and you're done, no headaches.

Using MS SQL Server, is there a way to query all of the tables in a database for a specific column name?Thanks,Pete ...

When you define a column in MS SQL server as either decimal or numeric (these are both options but do the same thing) you need to define a fixed precision and scale value for that column.

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.