February 9, 2012 at 12:46 pm
Hi All,
I am trying to import data from sql server database into excel (Version Microsoft office 2003)file.
How i Need to load is,
In the 1st cell of the excel file I need to display the static name along with currentdate. after that i need to skip 4 rows and from 5th row on wards i need to insert data.
Below is the sampel formate.
Plz kindly help me in this regard.
Name - 02/08/2012
Location Touch_When Touch_By Created_By
1770 Japan22:03.1 b1263fd9_mcampos1b1263fd9_samuel
1770UK 22:03.1 b1263fd9_mcampos1b1263fd9_jim
Thanks,
Venkat
February 10, 2012 at 1:29 am
I would create 2 named ranges:
one for row 1 and the first 2 columns, to store the name and date.
one for the data starting at row 5.
You can write to a named range like a normal table.
Excel Destination (check the Important section)
Write the name and the data first and in a seperate dataflow the data.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 2:41 am
If you don't mind can you explain little bit clearly.
February 10, 2012 at 2:46 am
padmanabhuni.k (2/10/2012)
If you don't mind can you explain little bit clearly.
It was pretty clear, to be honest.
Which bit don't you understand?
February 10, 2012 at 2:56 am
Hi thanx for your reply.
In SSIS I dont know how to create named ranges to load data into excel.
February 10, 2012 at 3:10 am
You create the named ranges in Excel, not in SSIS - they are part of the spreadsheet.
February 10, 2012 at 3:18 am
padmanabhuni.k (2/10/2012)
Hi thanx for your reply.In SSIS I dont know how to create named ranges to load data into excel.
Excel Names -- Excel Named Ranges
It is the first Google result for excel named ranges
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply