SQL Server Performance

Dts Failing with no error information.

Discussion in 'SQL Server DTS-Related Questions' started by droesch99, Oct 31, 2003.

  1. droesch99 New Member

    I have a very simple Dts Package, that copy a database from one server to another. The catch is the same package that worked a few weeks ago is now failing with no changes to it.

    The database is close to 30 gigs, and it creates the schema, then bombs when it transfers the data. The login has full rights to everything. I cannot see a specific error to it.. Any clues..?

    Is there a limit for BCP...??


    -David Roesch
    San Diego, Ca
  2. Luis Martin Moderator

    No space problem, I gess.

    How about to create a new job same old and try?. (S.. happens)

    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  3. satya Moderator

    Check space available on Tlog file and also check disk space where it resides.
    Check DTS package log for full details on execution.
    (I've deleted the other duplicate post)
    Satya SKJ
  4. sanjoo New Member

    Public Sub tracePackageError(oPackage As DTS.Package)
    Dim ErrorCode As Long
    Dim ErrorSource As String
    Dim ErrorDescription As String
    Dim ErrorHelpFile As String
    Dim ErrorHelpContext As Long
    Dim ErrorIDofInterfaceWithError As String
    Dim i As Integer

    For i = 1 To oPackage.Steps.Count
    If oPackage.Steps(i).ExecutionResult = DTSStepExecResult_Failure Then
    oPackage.Steps(i).GetExecutionErrorInfo ErrorCode, ErrorSource, ErrorDescription, _
    ErrorHelpFile, ErrorHelpContext, ErrorIDofInterfaceWithError
    MsgBox oPackage.Steps(i).Name & " failed" & vbCrLf & ErrorSource & vbCrLf & ErrorDescription
    End If
    Next i

    End Sub

    Call This Function before gopackage.execute

    SQL is love

Share This Page