There is a daily job that executes a DTS package that imports a flat file into a table on a SQL SVR 2005 database. When the DTS package executes, if the daily file is empty it abends.
1. What is the most efficient way to check the number of records in the file before calling the DTS package?
2. OR is there a property setting that will allow the DTS package to check the number of records, before attempting to import?
The code is written in VB6. I am looking for an efficient way of handling this issue.
This is my first experience working with DTS. This package was written in 2003 by another developer.
Thank you in advance for your technical assistance.
Start Free Trial
