Extracting data from a Progress SQL database truncates varchar columns.
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
99% of the time all is well but I've just discovered a really strange issue.
The database designer (bless her/him) 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 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 truncated string i.e. 04;09:00 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?
If fishing was easy it would be called catching
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
99% of the time all is well but I've just discovered a really strange issue.
The database designer (bless her/him) 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 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 truncated string i.e. 04;09:00 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?
If fishing was easy it would be called catching