upload files & default column value

Question

upload files & default column value

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

In order to have different timestamps on every row, you would have to change the batchsize to "1", but it would end up slowing down everything and I'm not sure this is what you want.

Hope this helps

Gianluca

-- Gianluca Sartori

Orlando Colamatteo SSC Guru Points: 182293 More actions · Answer 2

It sounds like you want to know the row in the database that corresponds to the first line in the file, and the second, and so on. To do that the only way is to set the batch size to 1. Here is a thread with a demo:

http://www.sqlservercentral.com/Forums/FindPost1127805.aspx

It makes use of an identity column to know to which line in the file each row corresponds.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato