May 27, 2014 at 10:53 am
I used the ssis import and export wizard to set up and export from sql to excel and the export works. But the file I am inserting into has the first 25 rows already filled in so I need to start at row 26. I cant seem to find a way to make it start at anything other than row 1. Any help would be appreciated. I am using visual studio 2008 and sql 2008 r2
May 27, 2014 at 12:43 pm
Try using a range to write to instead of a sheet name.
(never tried it in a destination though)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 27, 2014 at 12:59 pm
not sure where to do that
May 27, 2014 at 1:02 pm
Here's a blog post on how to do it in a source:
http://sqlserversolutions.blogspot.be/2009/02/selecting-excel-range-in-ssis.html
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply