VB script to know the size of the file for DTS

• id_vundadu

  SSC-Addicted

  Points: 413

  More actions

  March 10, 2011 at 6:23 pm

  #389028

  i have data in txt files for the period of one month , i have 30 files I have to ran a dts package in which it has to pick up a file every day.

  the issue is I have some zero size (0kb) files in that. when the proces of dts comes to pick up the 0kb txt file its shows an error.

  I want to add a vb scrpt to know size of the file so that i can manage the dts.

  Thanks.

• CGSJohnson

  SSCertifiable

  Points: 7208

  More actions

  March 11, 2011 at 5:44 am

  #1297556

  Look into the FileInfo class/object. I believe that it has the information that you need. Hope that this helps.

  Thanks...Chris