Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

convert datatype using derived column transformation Expand / Collapse
Author
Message
Posted Wednesday, August 19, 2009 3:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 6:08 AM
Points: 1,079, Visits: 591
Hi,

If anyone has used the logical and on the Derived column data flow please provide woth an eg.

Ta,
Duda


What you don't know won't hurt you but what you know will make you plan to know better
Post #773322
Posted Wednesday, August 19, 2009 3:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 6:08 AM
Points: 1,079, Visits: 591
Hi,

If anyone has done a logical and used on a Derived column data flow item please provide some code as mine is not working because of the syntax error.

Tx,
Duda


What you don't know won't hurt you but what you know will make you plan to know better
Post #773326
Posted Wednesday, August 19, 2009 4:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 6:08 AM
Points: 1,079, Visits: 591
Tx i manged to get this.

Wanted soming like :
EXPRESSION
QTY > 0 && TYPE == "ORDER" ? "O" : "I"


What you don't know won't hurt you but what you know will make you plan to know better
Post #773344
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse