I have a DTS package that loads text files. One of the
file created by mainframe (Security.dat) sometimes has 0
bytes in it.

While executing DTS Package, I need to check if the
Security.dat file is 0 bytes. If it is, I need to leave
the Security (Table that the data goes into)table alone.
If it is not 0 bytes (meaning some data is in it), I need
to delete the current data in the Security table and load
the new data from Security.dat file.

Can anyone send me a script (or any other way) to do this ?

Thanks for any help.

You could use an ActiveX task at the start of the process, and use vbScript
to determine the length of the file, and then in that vbScript delete it if
it's not zero length.


"Cindy" <cmorrison (AT) hotmail (DOT) com> wrote

Use an Active Script task.

Check the size of the file using the FileSystemObject

http://www.aspfaqs.com/ASPscripts/Pr....asp?FAQID=125

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Cindy" <cmorrison (AT) hotmail (DOT) com> wrote

In article <098f01c36673$1f540ca0$a001280a (AT) phx (DOT) gbl>, Cindy
<cmorrison (AT) hotmail (DOT) com> writes
Some examples including file sizes and deleting files here -

Working with files and the FileSystemObject
http://www.sqldts.com/default.aspx?6,101,292,0,1
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com