Re: DTS tasks not working

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm using DELETE FROM. Maybe that's the issue.
The data is constantly changing throughout all 4 tables. I just figured it
be easiest to dump the old and grab the new instead of comparing record by
record.
thanks!

"Randall Arnold" <randall.nospam.arnold@xxxxxxxxxx> wrote in message
news:%23pJgKNgbGHA.4672@xxxxxxxxxxxxxxxxxxxxxxx
How are you deleting the data-- truncate table? Have you tried leaving
the old data and only copying over new rows (using SQL instead of a bulk
table copy) that makes sure the rows are unique?

Randall Arnold
"shank" <shank@xxxxxxxxxxxxxxx> wrote in message
news:%23c8gsYebGHA.3632@xxxxxxxxxxxxxxxxxxxxxxx
I have a DTS package with about 20 steps.
It's all simple tasks. Nothing elaborate.
I'm working with 2 remote shared SQL servers. SQLA and SQLB
The DTS package is saved on: SQLB
The package empties 4 tables on SQLA (DELETE FROM tasks)
Then populates those tables with a bit of data grooming.
Last step is to transfer the new data to SQLB.
I set the parallel processing limit to 1.

If I execute the DTS manually - it works perfect.
If I allow the schedule to run the DTS - data is duped in all the tables.
Every morning I wake to duped data.

I can only guess that the first set of data is not being deleted.
How can I troubleshoot this?
I don't have any control over scheduling.
Are there any settings there that can effect this?

thanks!





.

Relevant Pages

  • Re: DTS tasks not working
    ... I'm working with 2 remote shared SQL servers. ... The DTS package is saved on: SQLB ... If I execute the DTS manually - it works perfect. ... Every morning I wake to duped data. ...
    (microsoft.public.sqlserver.dts)
  • strange error on DTS scheduling
    ... I am getting this strange error while scheduling a DTS. ... What I am trying to do is copy data from DB2 on mainframe to a SQL ... I added the domain/SQLADMIN to Admin group in the server. ... When I schedule it as a job. ...
    (microsoft.public.sqlserver.dts)
  • strange error on DTS scheduling
    ... I am getting this strange error while scheduling a DTS. ... What I am trying to do is copy data from DB2 on mainframe to a SQL ... I added the domain/SQLADMIN to Admin group in the server. ... When I schedule it as a job. ...
    (microsoft.public.sqlserver.server)
  • Re: Automated DTS package will not run
    ... if owner of job is member of sysadmins fixed serverrole then job will run ... dts in job owner's context ... could you check the job schedule. ...
    (microsoft.public.sqlserver.security)
  • Re: DTS job error
    ... the DTS schedule package functionality - you right click on ... the package on select Schedule Package. ... DTSRUN /~Zxxxxxxxxxxxx. ...
    (microsoft.public.sqlserver.server)