September 11, 2014 at 8:43 am
I have a job that retrieves log files from an FTP site, then restores them into a local database.
The issue I am having is if a log file is empty, the restore aborts and I have to remove the empty log file from the directory. Then restart the process.
Is there anything I can run that will let me know that the logfile is empty so I can automate this process?
September 11, 2014 at 11:53 am
What is the method you are using to load the log file into the database? SSIS, bulk insert, etc?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy