Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Mumbai
    Posts
    1

    Unanswered: DTS Package error

    Hi,
    I am using a DTS package to retrieve data from one set of tables /flat files and load into another set of tables. The package is scheduled to run daily. After the failur/success of every step I get an email notification.
    But sometimes the package starts, i get the email notification for that ..and then the package never proceeds. Neither I get a failure message nor the success message for the next step. When i checked in the log files I got the attached file, with the error code
    8004043B.

    This package calls some other packages. But what I feel is that its not completing even the first step.Hence the child packages are not being called.

    Please help!!!!
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Enable logging for this package, so that the error message will be recorded in the log file.

    Try setting the "Execute on main package thread" option. Right-click the
    task, Workflow Properties, Options tab.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144

    Lightbulb VB executable ?

    Are you calling an external VB executable through your DTS ?

Posting Permissions

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