Top line only!

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

Phil Parkin SSC Guru Points: 246985 More actions · Answer 1

As far as I can see, not natively. But a Script Task will, of course, do it for you fairly simply.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

bas de zwart Ten Centuries Points: 1117 More actions · Answer 2

You could try the Bulk Insert command, it has an option to limit the number of rows:

Phil Parkin SSC Guru Points: 246985 More actions · Answer 3

bas de zwart (5/18/2010)

You could try the Bulk Insert command, it has an option to limit the number of rows:

By using LASTROW = 1, I guess. Nice idea.

Here is your link again, this time as a hyperlink, for those who are too lazy to cut&paste: 🙂

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

bas de zwart Ten Centuries Points: 1117 More actions · Answer 4

Yup, that's the one. 🙂

Been using that to import millions of rows and very quickly at that.

imani_technology SSCrazy Eights Points: 8200 More actions · Answer 5

So, I should create an Execute SQL Task and put a BULK INSERT command within that task -- is that correct?