Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    46

    Unanswered: Run Access Sub from DTS Package??

    Does anyone have any experience with running an Access subroutine from a DTS package (vbscript)? I've tried using the Call function & get the following error. (also tried changing the sub to a function, but still get the error)

    Error Source: DAO Properties

    Error Description: Error Code 0
    Error Source = Microsoft VBScript runtime error
    Error Description: Type Mismatch: 'Att4Sum2'

    Error on Line 8

    Property not found.

    Here's my vbscript code in the DTS package:

    Function ExportAttachmentData()
    Dim objDB
    Set objDB = CreateObject("Access.Application")
    objDB.OpenCurrentDatabase("C:\DBReports.mdb")
    Call Att4Sum2
    objDB.CloseCurrentDatabase
    objDB.Quit
    ExportAttachmentData = DTSTaskExecResult_Success
    End Function

    Thanks!
    Brian

  2. #2
    Join Date
    May 2002
    Posts
    46
    bump bump bump

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •