Import File.. Pre task
Trying to figure out if there is a way to do this..
I have a import map but I’m logging it in sql with a pre import task. So if I run the map and there is no file, the log starts & ends. If I run the map waiting a file every X minutes, it’ll start the log file X times till the file is there. Is there anyway to check for a file before running a map ? This way my logging isn’t going crazy waiting for a file. Or is there a better way to do this ? thanks
I have a import map but I’m logging it in sql with a pre import task. So if I run the map and there is no file, the log starts & ends. If I run the map waiting a file every X minutes, it’ll start the log file X times till the file is there. Is there anyway to check for a file before running a map ? This way my logging isn’t going crazy waiting for a file. Or is there a better way to do this ? thanks
Answers
Ok I think I can solve this using the real time folder data source instead of scheduling.
This way it’ll only run when there is a file change.
This way it’ll only run when there is a file change.
So I think this is the way Ill go using the real time folder monitoring to determine if file exist. How reliable is this service.. I know windows service sometime crashes, is there any way or any health checks on monitoring service or I’m on my own?
I have done some if service crashes, restart/send email alerts.. just want to get a sense how involve it is.
Thanks
I have done some if service crashes, restart/send email alerts.. just want to get a sense how involve it is.
Thanks