Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

File quantity, date, size verification in Windows 2000 server?

Mar 9, 2004 4:38AM PST

Hello All,

I am working on a project which requires me to output 4 data files, every day, from an SQL database to be sent to a mainframe server.
Part of my project requires me to create a verification log of these files to determine that they were created on the correct day, the file size is approximately 20-40 Kb in size for each file and that there are indeed 4 files.

Is there a way for server 2000 to create this information? or from SQL 2000 (the DTS will create these files)? or a batch file or 3rd party app?

Please let me know at your convenience.

Thanks,

Richard

Discussion is locked

- Collapse -
Re:File quantity, date, size verification in Windows 2000 server?
Mar 9, 2004 5:00AM PST

In the simplest of logs, after my code has created the files, mind you didn't tell what language the code is in , so I'll use a script/batch file to add to the logfile.txt

After the files are created just script this...

ECHO Logging file creation >> LOGFILE.TXT
DIR *.DAT >> LOGFILE.TXT

Given your specification, these two lines of script should suffice.

Bob

- Collapse -
Re:File quantity, date, size verification in Windows 2000 server?
Mar 9, 2004 5:34AM PST

I appretiate the feedback. When I run your two likes of code in a batch file I recieve the following:

Logging file creation
Volume in drive C has no label.
Volume Serial Number is B8AC-948E

Directory of C:\Test Directory


(I do not receive any information of the 10 files I have in this Test Directoy) Any Ideas?

Thanks!

Richard

- Collapse -
Try *.*
Mar 9, 2004 5:58AM PST

I don't know the names of the files in question. My example was just an example...