Copy files by date

• alorenzini

  SSCarpal Tunnel

  Points: 4620

  More actions

  February 25, 2008 at 10:59 am

  #74050

  I have to setup a DTS package that will copy multiple files from one folderto another folder based on a date range and file type. Can I achive that through a ActiveX script and if so how?

  After the copy then I will need to import the individual tables into a SQL table. How may I achive that?

  Thanks,
  Art
  Database Analyst
  Tastefully Simple, Inc.

  alorenzini@tastefullysimple.com
  " Some days, it's not even worth chewing through the restraints!

• Norman Kelm

  SSCommitted

  Points: 1922

  More actions

  February 26, 2008 at 7:02 am

  #781967

  Hi Art,

  Yes, use the FileSystemObject in the ActiveXScript task.

  The following articles give detailed examples:

  http://www.sqldts.com/246.aspx

  http://www.sqldts.com/304-2.aspx

  FileSystemObject documentation is available on msdn.

  Norman Kelm

  DTS Package Search

  http://www.dtspackagesearch.com/