SSIS Time Expression | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SSIS Time Expression

All, 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.. Thanks..Ad
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

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |