May 30, 2013 at 1:29 am
hi guys
i have excel souce with data that i need to import into oledb destination, here's an example of my the import
INVOICE DESCRIPTIONPOSTING DATE
Posted 20111010
Posted 0
completed 20120727
completed 20120806
Posted 0
Posted 20120806
i've created a derived transformation to format posting date field of which that works fine
(DT_DATE)(SUBSTRING([POSTING DATE],1,4) + "-" + SUBSTRING([POSTING DATE],5,2) + "-" + SUBSTRING([POSTING DATE],7,2))
now what i want to do is if INVOICE DESCRIPTION <> 'Posted' then set POSTING DATE to null and to the import.
please help
May 30, 2013 at 1:42 am
Nomvula (5/30/2013)
hi guysi have excel souce with data that i need to import into oledb destination, here's an example of my the import
INVOICE DESCRIPTIONPOSTING DATE
Posted 20111010
Posted 0
completed 20120727
completed 20120806
Posted 0
Posted 20120806
i've created a derived transformation to format posting date field of which that works fine
(DT_DATE)(SUBSTRING([POSTING DATE],1,4) + "-" + SUBSTRING([POSTING DATE],5,2) + "-" + SUBSTRING([POSTING DATE],7,2))
now what i want to do is if INVOICE DESCRIPTION <> 'Posted' then set POSTING DATE to null and to the import.
please help
Sounds like you need a conditional expression. Something like this:
[INVOICE DESCRIPTION]<> "Posted"? NULL(DT_DATE): (DT_DATE)(SUBSTRING([POSTING DATE],1,4) + "-" + SUBSTRING([POSTING DATE],5,2) + "-" + SUBSTRING([POSTING DATE],7,2))
--edit, obviously you need <> in your code, not that ltgt HTML garbage.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
May 30, 2013 at 1:53 am
it worked like a charm
thank you so much
May 30, 2013 at 2:06 am
Great, thanks for posting back.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply