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-01-12 : 11:14:00
|
Buddy writes "I have a situation where I need to lookup the "last load date" for a file in a database and compare it to the date of the current file to determine if new data needs to be loaded.
I can do this very easily with SQL2000, using the Execute SQL Task Object and global variables, however, I am stuck with SQL 7 on this project. I know you folks don't normally do syntax questions, but I've every source I have, and can't find any examples. I'm hoping that someone has had to do the same thing before.
I have created a lookup on an existing Data Driven Query task to find my upload date. I am trying to execute this lookup from a separate ActiveX script task. This task would execute prior to the DDQ.
I can see the lookup using the Package object model, however, it doesn't support an execute method. The DTSDataPumpLookup object does support execute, but I can't seem to reference it properly, and I can't find example source code on it. Can you provide an example of how to set a reference to this object? Is there a better way to accomplish my goal (other than SQL2000)?
I am trying to use DTS connection and lookup objects rather than creating an ADO/DMO connection and executing SQL within the ActiveX script as this technique appears to slow down execution a great deal.
Thanks in advance for your help,
Buddy" |
|
|
|
|
|
Referencing a DTSDataPumpLookup collection/object from ActiveX Task in DTS