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

dateadd expression is ssis is not validating Expand / Collapse
Author
Message
Posted Sunday, October 21, 2007 11:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 10, 2007 9:28 PM
Points: 11, Visits: 7
Hi, I am using following expression in SSIS
DATEADD( "hour" , TT_DETL_TO_TM_ZN_OFST , TT_DETL_POD_DTT)

and here the number field and the date fields are columns coming from source

any idea is I am missing something.

Thanks in advance.
Post #413264
Posted Monday, November 19, 2007 3:11 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 5:11 AM
Points: 24, Visits: 66
Try

DATEADD( "hh" , TT_DETL_TO_TM_ZN_OFST , TT_DETL_POD_DTT)
Post #423825
Posted Wednesday, September 25, 2013 8:36 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 04, 2014 3:57 PM
Points: 159, Visits: 317
this doesn't work in SSIS

DATEADD( "hh", [TimeZone] ,[DockDepartureTime] )
Post #1498406
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse