Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-23 : 09:32:00
|
| Brian writes "Is there a way to use functions such as DATEADD and DATEDIFF in the transform data task properties screen in DTS. Under the Source Tab and Having SQL Query selected I wanted to limit the amount of information that is transferred to the database using functions but it keeps coming up with different types of errors.I already have a working statement but that limits other fields but when I add in the WHERE part((DATEDIFF(dd, (DATEADD(ss, SHIP_DATE, '1/1/1970')), GETDATE())) < 8)First the DATEADD function is trying to take the field SHIP_DATE which is in seconds from 1970, add it to 1/1/1970 so that it has a normal format, then find the fields where the date in SHIP_DATE is within the last 7 days from GETDATE. I'm not sure that DTS allows functions like GETDATE and DATEADD or if I'm not writing it correctly." |
|
|
|
|
|
DTS Functions