I have posted at SQL Server forums but maybe you guys can help.
Environment :
Windows 2000 SP 4
MS SQL Server 2000 Microsoft SQL Server 2000 - 8.00.760
Standard Edition (Build 2195: Service Pack 4)
ODBC Driver is DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E
I'm extracting data from Progress db using MS SQL DTS packages.
99% of the time all is well but I've just discovered a really strange issue.
The database designer has used a string (varchar(16)) column to hold times e.g 04;09:48 = 4 days, 9 hours and 48 minutes.
I need to do some interval calculations so I have a SQL Server stored procedure to update a new column as whole minutes.
So far - so good.
However, if I run the DTS package from the desktop it works fine. But when it runs as part of a scheduled overnight job some records in the destination table, and only some, have a corrupt string i.e. 04;09:00 (minutes missing) and some are 'zero' i.e. 00;00:00.
If I schedule the package to run during the day and then check the result the result is as expected 04;09:48.
This is making my head hurt
Anyone have any suggestions for diagnosis or resolution?
Environment :
Windows 2000 SP 4
MS SQL Server 2000 Microsoft SQL Server 2000 - 8.00.760
Standard Edition (Build 2195: Service Pack 4)
ODBC Driver is DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E
I'm extracting data from Progress db using MS SQL DTS packages.
99% of the time all is well but I've just discovered a really strange issue.
The database designer has used a string (varchar(16)) column to hold times e.g 04;09:48 = 4 days, 9 hours and 48 minutes.
I need to do some interval calculations so I have a SQL Server stored procedure to update a new column as whole minutes.
So far - so good.
However, if I run the DTS package from the desktop it works fine. But when it runs as part of a scheduled overnight job some records in the destination table, and only some, have a corrupt string i.e. 04;09:00 (minutes missing) and some are 'zero' i.e. 00;00:00.
If I schedule the package to run during the day and then check the result the result is as expected 04;09:48.
This is making my head hurt
Anyone have any suggestions for diagnosis or resolution?