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 |
|
mfemenel
Professor Frink
1421 Posts |
 Posted - 2001-09-26 : 10:49:07
|
| Ok, I went to SQLDTS.com first(sorry Graz). They had nothing on this. I'm trying to find an example of how to use a Lookup in a DTS job. Not a Global variable, a lookup. Here's the issue. We have data processing box, and our production server. Our data box imports from an Oracle database, maniuplates the data and pushes it off to production. We import the data from Oracle via DTS...no need to suggest alternate ways, we're sticking with it. However, each month, we have to go into the package and change the dates for example, in to pull charges for the month. We'd like to make this table driven so we can set an interface up for our users(who do not/will not) have SQL access. Thus keeping us programmers out of the process and keeping end users from essentially irritating us by calling and asking "when you gonna change the dates?"Mike "Anyone think someone else is stupid, he/she is the stupid. " |
|
|
|
|
|
DTS_Lookups