Hi!
I have a Fact_data flow with several Lookups.
In one there's OLE Db source DT_14 (persons id's) which need to be compared to a column DT_18 from Dim_salesperson. Thats how I could collect the ID's from Dim_salesperson into OLE DB Destination. How could I compare, DT_14 data with DT_18?
First converting DT_14 to character. Secondly char to DT_18?
I would be so grateful if someone could give an idea...
curiousss wrote:
First converting DT_14 to character. Secondly char to DT_18?
Assuming you are talking about DT_I4 and DT_I8; that approach sounds reasonable. Have you try it?
|||Thanks, problem solved!
No comments:
Post a Comment