Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by wondemh
-
How to update SQL Server table using DTS
Hi all, I need to update my SQL Server 2000 tables with rows from an Oracle table. Using a DTS package, how can I get only rows from the Oracle table that have a date value greater than the maximum date from the SQL Server table? Thanks Henok- wondemh
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Hi Terry, Thanks for your reply
Hi Terry, Thanks for your reply to my previous question regarding global variables. I visited Daren Green's SQLDTS website. But he focused on actually doing the coding in VBScript for SQL Server 7. I am using SQL Server 2000 and I am creating these global variables using GUI interface. I...- wondemh
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Help on using DTS global variables to select rows from Oracle table!
Hi folks, I am trying to do an incremental update on my tables in SQL Server. I am trying to do this by pulling rows from an Oracle table that have an activity date that is more recent than most recent date in the SQL Server table. I am doing this using a DTS Package. In the package I have...- wondemh
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
