March 9, 2009 at 10:59 am
In my data flow I compare new data with existing data warehouse data
using "Table Difference" custom component.
I get 5 streams:
New
Unchanged
Deleted
Update
Historical
I connect all the streams to "Union All".
To help me to identify the stream I added to each stream derived columns:
"Stream_New"
"Stream_Unchanged"
etc.
By default this column goes to the end of column list.
Is there a way to change that column list order
and to show my "Stream_New" as the first column
inside "Union All Input 1", "Union All Input 2", etc.
March 9, 2009 at 11:50 am
Show it where?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2009 at 12:10 pm
Show it as first column inside "Union All Input 1", "Union All Input 2", etc.
March 9, 2009 at 12:40 pm
Why does the column order matter here?
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
March 9, 2009 at 1:02 pm
Cos if you have 40 columns you don't want to scroll down
to verify the stream. You want to see the stream at the top
as a header.
March 9, 2009 at 1:44 pm
riga1966 (3/9/2009)
Cos if you have 40 columns you don't want to scroll downto verify the stream. You want to see the stream at the top
as a header.
Trusting SSIS to "guess" correctly will be your undoing. It's easy to get complacent with that, since it sometimes gets it right - but every time I've started to count on t "understanding" what I wanted - it then proceeds to bite me in the 4th point of contact.
Review the mapping, and make sure it's right. Sure it takes longer, but it's better than the alternative.......
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 10, 2009 at 8:56 am
Apparently there is a very simple solution.
I just named that header dummy column as
"A_NEW"
"A_CLOSE"
"A_UPDATE"
and inside "Union All" sorted list by column name.
I get my header at the top now.
March 10, 2009 at 6:42 pm
riga1966 (3/10/2009)
Apparently there is a very simple solution.I just named that header dummy column as
"A_NEW"
"A_CLOSE"
"A_UPDATE"
and inside "Union All" sorted list by column name.
I get my header at the top now.
I think that you could make this a bit simpler still by using names like:
_NEW
_CLOSE
_UPDATE
Which should sort even before "A_...".
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply