Post reply

Copy files by date

  • 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!

  • 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/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply