Post reply

DTS TRANSFORM

  • October 10, 2008 at 8:11 am

    #383032

    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

    #883438

    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

    #883456

    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

    #883461

    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