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


    -David Roesch
    San Diego, Ca
    droesch99, Oct 31, 2003
    #2

  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
    Luis Martin, Oct 31, 2003
    #2

  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
    Moderator
    SQL-Server-Performance.Com
    satya, Oct 31, 2003
    #2

  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
    sanjoo, Nov 11, 2003
    #2

Share This Page