SQL Server Performance Forum – Threads Archive
Dts Failing with no error information.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
San Diego, Ca
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.
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)
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
Next i End Sub
Call This Function before gopackage.execute SQL is love