August 2, 2016 at 8:20 am
Does anyone know how I can get the values in the first column of the spreadsheet to pertain to the data in the second column.
The first column is a merged column with the data heading set vertically. The data column in the first column relates to all the data in the second column.
So the source file looks like the above however I want to load the data as:
ADVERTISING & MARKETING Radio
ADVERTISING & MARKETING Television
ADVERTISING & MARKETING Newspapers
ADVERTISING & MARKETING Magazines etc
Anyone any ideas or pointers to handling this kind of layout?
Many thanks in advance.
August 2, 2016 at 8:31 am
What happens when you try to read it in SSIS? Will it parse, or do you get an error?
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
August 2, 2016 at 11:11 am
Hi All
I found the solution right here on SQL Central, after lots of heartache, frantic Googling and numerous SSIS testing.
The answer is here:
We had this on this site however the topic heading was awful and I just happened to find it as I thought it was related to something else.
https://ericwisdahl.wordpress.com/2009/08/02/ssis-retain-values-from-previous-rows/
August 2, 2016 at 12:25 pm
pnr8uk (8/2/2016)
I found the solution right here on SQL Central, after lots of heartache, frantic Googling and numerous SSIS testing.
The answer is here:
We had this on this site however the topic heading was awful and I just happened to find it as I thought it was related to something else.
https://ericwisdahl.wordpress.com/2009/08/02/ssis-retain-values-from-previous-rows/%5B/quote%5D
Here is a clickable version of your link, for any lazy SSC readers 🙂
https://ericwisdahl.wordpress.com/2009/08/02/ssis-retain-values-from-previous-rows/[/url]
I knew about this technique, that's why I asked the question I did. But well done on tracking it down yourself.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply