With the search feature unavailable today, I'm hoping
no one will mind a direct question.
I have created a DTS package that will drop and recreate a
table within my database based on a flat file received from
an external vendor that is placed on an internal common
server share.
What I would like to do is determine the date of the file
to see if it is "fresh" before processing it. If the file
is "fresh," then launch my related DTS package to import
that data.
Would someone be able to suggest a good course of digging
where I might learn that aspect? I've typically done loose
database/table management but I am new to job scheduling.
no one will mind a direct question.
I have created a DTS package that will drop and recreate a
table within my database based on a flat file received from
an external vendor that is placed on an internal common
server share.
What I would like to do is determine the date of the file
to see if it is "fresh" before processing it. If the file
is "fresh," then launch my related DTS package to import
that data.
Would someone be able to suggest a good course of digging
where I might learn that aspect? I've typically done loose
database/table management but I am new to job scheduling.