Problem with DTS (Data transformation services) SQL Server 2000

[Former Member]

I need to transfer some tables from a SBO database to another SQL database (not SBO in the same server) with DTS launched in a batch file scheduled in windows planned operations.

But sometimes (RANDOM) some source tables (ex. OINV, INV1) are not transferred in destination tables wich results empty without any errors.

Anyone ever found a problem like this?

Maybe some SBO service conflicts or something like this?

Thanks

[Former Member]

Hi Valentina,

DTS would not be affected by anything SBO is doing. Have you checked the SQL logs to see if DTS or SQL Agent is reporting a problem?

Is it possible that the insert in to your other database could be failing (eg a Null value in a SBO table in to a column that doesn't accept Nulls)?

Kind Regards,

Owen