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 |
|
ChickenLegs
Starting Member
2 Posts |
 Posted - 2007-02-22 : 05:28:50
|
| I have created a SQL 2000 DTS to bullk import a table from Oracle. This is slow due to the size of the oracle table and I am now trying to pull data from the table as net change - so anything that has been inserted or updated in Oracle on the previous day. As soon as enter dates in the WHERE clause or try getdate() the package won't parse or run. The error message is unhelpfully blank. How do I specify Oracle date parameters within the DTS? SYSDATE?Any advice would gratefully received. Thanks |
|
|
ChickenLegs
Starting Member
2 Posts |
Posted - 2007-02-22 : 12:48:46
|
| Got it working using SELECT SYSDATE FROM DUAL |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-22 : 13:48:06
|
| http://sqldts.com is a good resource for all things DTS..-ec |
|
|
|
|
|
|
DTS error import from Oracle (on dates)