November 18, 2001 at 2:54 am
Log file creation differs between DTS and VB Module? Why?
I created a DTS package in SQL-2000 with Win2k server. I saved the same DTS package as VB module. Then
i tried to execute the same thro' VB. It is running fine in both the ways. It is creating a log file
in dtssteplog table under MSDB database. There is a field progresscount where it is storing number of
records successfully transmitted. In case of execution thro' DTS it is storing no. of records transmitted
correctly, whereas in the case of VB it is always storing no.of records transmitted as 0. Is there any
solution to this prob. If so pl.mail to me. I downloaded the SP1 of SQL-2000 also. After installation
of SP1 also the same problem continues. Pl. let me know if you have any answer to this prob. Thanks
in advance to all of you.
November 19, 2001 at 10:18 am
I'll take a look, but my guess it VB is reporting the number of rows back to the application, not MSDB.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply