i have this problem:
i am generating every 2 hours 4 comma delimited file with filename as1, as2, as3, as4 in order to import them using a dts in my mssql 2000 db sequentialy. the files can be of 0kb or have data in it.
in my dts i am importing all 4 files in the db. now i get an execute error for the files that are of 0kb. the files with data are imported which is ok.
but how can i make the dts to do not execute the importing of files that are of 0kb and do only the import of files that are > than 0kb.