October 10, 2008 at 8:11 am
Hello:
I am trying to transform a flat file in SSIS which is fine but the problem i have is that this file has 2 different conditions that i need before i transform...
(i.e. If DTSSource("Col005") = "E" Then
DTSDestination("Col001") = DTSSource("Col001")
DTSDestination("Col002") = DTSSource("Col002"))
anyway of doing this in SSIS?
Thanks
F.
October 10, 2008 at 8:23 am
You want to either use a derived column component or a conditional split. If you post more details, I could be more specific on what you need to do.
October 10, 2008 at 8:34 am
The condition has to be done before i transform as the data coming in differs for example
if col005 = 'E' it's numeric if col005 = 'Z' it's character
October 10, 2008 at 8:41 am
You have not given me any clue what "it" is, but I will still try one last post.
Add a derived column component to the data flow.
in the component, add two columns, one of type integer and the other of type string.
Your expressions will look something like:
For the integer column:
([col005]=='E') ? [colData] : 0
For the character colums:
([col005]=='Z') ? [colData] : ""
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply