Pkg not transferring rows

• lenny

  Valued Member

  Points: 53

  More actions

  September 24, 2004 at 6:55 am

  #59520

  I'm using xp_cmdshell/dtsrun to execute a package in a job that (sequentially) modifies data in one SQL Server database, transfers rows to a second SQL Server database, and modifies data again in the first database. When it successfully completes, all data modifications are made to the first database, but no rows are transferred to the second. Any ideas what might cause this?

  Thanks!

  -Lenny

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 24, 2004 at 10:57 am

  #524378

  Do any steps fail?  Try logging all the package steps and examine the resulting log files to see what happens.

  Greg

  Greg