November 16, 2012 at 10:33 am
How to export the first 100 rows of an excel file to a flat file ?
In excel file have 2000 rows, we need to export only 100 rows..
Please anyone help me..
Thanks
Jerry
November 16, 2012 at 11:45 am
Can't you just do a [font="Courier New"]SELECT TOP 100 *[/font] from the Excel source?
Or alternatively, take a look at: http://geekepisodes.com/sqlbi/2010/ssis-skipping-rows-and-columns-in-excel/
HTH,
Rob
November 16, 2012 at 12:40 pm
It is not working..
November 16, 2012 at 2:36 pm
solomon.jernas (11/16/2012)
It is not working..
Not working how? What's the error message? We can't see your system, so it's hard to give help without more information. Did you take a look at the URL above?
Rob
November 20, 2012 at 11:33 pm
you can use sqlcmd in execl source,
press buildquery,add table, then add top 100.that you can got it.
SELECT TOP 5 [2012-11-16], F2, F3, F4, F5, F6, F7, F8
FROM [sheet$]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply