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 |
|
ogarcia77
Starting Member
1 Post |
 Posted - 2004-11-16 : 13:49:22
|
| Hi all,I want to add ActiveX code so that the start time and the finish time for my DTS steps are recorded to another database.How do I invoke the StartTime and FinishTime properties in Active X?Part of my code is:Function Main() Dim myDestConn set myDestConn = CreateObject("ADODB.Connection") myDestConn.Open = "Provider=SQLOLEDB.1; Data Source=XX; Initial Catalog=XX; user id = 'XX'; password = 'XX'" myDestSQL = "INSERT INTO LOG_TABLE (DESC, START_TIME, END_TIME) VALUES ('DTS #1',' ',' ')" myDestConn.Execute myDestSQL Main = DTSStepScriptResult_ExecuteTaskEnd Function |
|
|
|
|
|
How to use StartTime and FinishTime