I have been trying to use DTS and ClientAccess. When I create a package it runs fine. Selects, writes, etc. As soon as I set this up as a Scheduled task it no longer works.
Have you been experiencing the same problems?
Thanks!
I use SQL 7.0 with my ASP and simply do a select statement.
Here is a snippet of my code:
cmd = "Select HolidayDate from HolidayMaster where HolidayDate = " & ShipDate & " and TerminalId = " & OrigTerminal
rs.Open cmd,cn
if rs.EOF then
ok = true...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.