One more question on date validation. We have a job which outputs a cvs file. I created another job, which will read the file and Join with a Query from SQL server. Both have date filed. (File and query).
How we can have a validation check to see both the date are equal or both the dates are same as parameter date.
So, if any how csv file date is 10/11 and odbc date is 10/12. Job should abort.
Any thoughts.
Design-
Code: Select all
odbc
|
SEQ---JOIN---SEQ