SQL Server Performance

SSIS Time Expression

Discussion in 'SQL Server 2008 Integration Services' started by Arman, Nov 23, 2011.

  1. Arman New Member


    I am working on creating an ssis package to move the data from one source to multiple destinations depending on Dates and Time for diffrent destinations.

    Can someone help in setting up Variable or Expression which i can use to specify time. e.g i need to move the data from Yesterday 7:00 AM to Today 7:00 AM.

    My major problem is to setup time not the date but if you have better solution for both i will take it..

  2. Shehap MVP, MCTS, MCITP SQL Server

    You could use the new 2008 data type "datetimeoffset(7)" and then you could use for your SSIS Package "SWITCHOFFSET " as for example below

    Select CONVERT(DATETIME,SWITCHOFFSET([startdate],'-08:00')) localdate from mytable

    I hope that could help you´╗┐

Share This Page