MS SQL Server DTS

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

compare

steve

2006-01-26, 4:58 pm

I am new SQL
I have XML files (jobs) that are generated from a third party app on a
weekly basis.

My SQL application loads the the xml files for production.

>From time to time changes will be made to the original xml files, which
requires a user to reload the job via the app.

However, the reporting process on these changes is somewhat anticquated
and sometimes these changes are missed and the job is not reloaded.

I am looking for a process to compare specfic dates values in the database
against either the file date on the xml files or the date that is
contained in the xml file and generate a report when the date is
in the DB is less then the file date

Any help is greatly appreciated.

Thank you

Sponsored Links