Originally posted by Brett Kaiser
How about bulk insert in to a work table with 72 columns?
Or how about using bcp with a format file?
Thanx For your reply.
The volume of data is very high hence inserting the data in a 72 column table and then transferring it into a 73 column table is not an efficient way of dooing it. Also, the size of log file (Transaction log) will increase if I copy the data from one table and insert another.
I do have a work around, where I drop the 73rd column using Alter Table Syntax and then add it back after the bulk insert is done.
I was hoping to get a solution where all this can be avoided if I could specify the number of columns in bulk insert command