Hello
The database we are working with is using Windows SQL 2000 (SP4)
We have been setting up a trail for evaluating the Advanced ETL Processor Enterprise product -
To date it was all quite straightforward, however we have struck a problem with a particular SQL procedure that is showing up as an error when we run the Export Package from the Repository. In the attached document (Package run time log file) you will see the errors that occur for the Export in the third Export for the procedure dealing with a join of 2 tables InvoiceHeader and InvoiceDetail
I can run the procedure in the SQL200 Query Analyser without see any errors and it returns the expected number of rows - 69,114
I suspect it is something to do with the SQL procedure and the way we have constructed the Join -
Would you please review and advise if there is an alternate method to achieve an error free run as at present the errors will cause the Package to fail and in the full package we have a number of procedures that require a table Join to extract the required data for export.
Let me know if you require any further information –
Thank you for your assistance –
Following is the procedure that is used in the Export Package -
select
xx,xx,xx
from InvoiceHeader, InvoiceDetail
Where InvoiceHeader.ID = InvoiceDetail.InvoiceID and cast (floor(cast(Date as float)) as datetime) = '05/31/2010'
Regards
Michael
