DTS package aborts without error!

DTS package aborts without error!

Post by Cind » Thu, 20 Dec 2001 10:46:40

When I run a DTS package which does a data pump from an
Access table to a DB2 table AND there is a zero value in a
numeric field, then the package aborts without an error,
closing SQL Enterprise Manager, leaving me at the
desktop.  The same package executes to completion if there
is either a null or a number greater than zero in that

Cindy R.


DTS package aborts without error!

Post by Lan Lewis-Bev » Wed, 09 Jan 2002 14:19:43

Does your DB2 table have any constrains that won't accept 0 value?

Lan Lewis-Bevan

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure?  For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit


DTS package aborts without error!

Post by Cindy Rutherfur » Sat, 12 Jan 2002 01:33:25

No, I already checked the constraints on the DB2 side.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


1. Error executing a DTS package from another DTS package

I'm trying to execute one package from another using the following ActiveX
script code:

Function Main()

Dim oPkq

Set oPkq = CreateObject("DTS.Package")

oPkq.LoadFromSQLServer "Server","myuser","mypass",,,,,"Old HBdb to New HBdb
for 4 Tables"

'oPkg.GlobalVariables("DatabaseName").Value = "mssdet"

MsgBox oPkg.Name


Set oPkg = Nothing

Main = DTSTaskExecResult_Success

End Function

I get an error at line (MsgBox oPkg.Name) on SQL 2000:

VBS Runtime Error 0

Object required 'oPkg'

Any ideas on what is wrong?


2. Printer paper size problems

3. Capture Error in DTS Package, From Inside DTS Package

4. activeX controlts

5. Gracefully aborting a DTS Package

6. Enter Mariah Vision 3Scape contest

7. Scheduling DTS package causes the job to abort

8. Case insensitive queries in D3

9. Gracefully aborting a DTS Package

10. Abort execution of a DTS package

11. DTS Aborts on package start

12. Aborting DTS package in mult-threaded .NET app

13. Aborting execution of DTS package