May 17, 2010 at 7:48 pm
Is there a way in SSIS 2005 to extract only the first line of a flat text file?
May 18, 2010 at 1:17 am
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 18, 2010 at 2:11 am
You could try the Bulk Insert command, it has an option to limit the number of rows:
http://msdn.microsoft.com/en-us/library/aa225968%28SQL.80%29.aspx
May 18, 2010 at 2:16 am
bas de zwart (5/18/2010)
http://msdn.microsoft.com/en-us/library/aa225968%28SQL.80%29.aspx%5B/quote%5D
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: 🙂
http://msdn.microsoft.com/en-us/library/aa225968%28SQL.80%29.aspx
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 18, 2010 at 2:18 am
Yup, that's the one. 🙂
Been using that to import millions of rows and very quickly at that.
May 18, 2010 at 11:34 am
So, I should create an Execute SQL Task and put a BULK INSERT command within that task -- is that correct?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply