Error executing from VB a transfer object task

• g.firpo

  Old Hand

  Points: 316

  More actions

  March 18, 2002 at 2:40 am

  #104801

  Hi, I have this problem:

  there is a package that executes a transfer object task to copy a db to another;

  I use a VB program to execute the package; this program handle the events from DTS.

  executing the package from a VB program I catch this strange error (in the OnError routine):

  Error code: -2147221499

  Source: Microsoft Data Transformation Services (DTS) Package

  Description: Need to run the object to perform this operation

  Help file: sqldts80.hlp

  Help context: 700

  The environment is Windows 2000 / SQL Server 2000

  Executing the package with E.M. is OK.

  I have a lot of packages that i run with the VB program,

  but only with this package i encountered this unsolvable problem.

  Anyone have an ideo of this kind of problem ?

  There is an alternative way to avoid this obstacle, but maintaing the control over the execution ?

  Thanks in advance

  Gianangelo