Post reply

DDQuery help in script

  • November 8, 2005 at 8:28 am

    #76453

    Hello!

    I need help because it's the first time i'm working with DTS.

    I have a table i need delete information

     12-07-2005 15:23:05

     12-07-2005 15:23:23

     12-07-2005 15:23:45

     12-07-2005 15:24:04

     12-07-2005 15:24:24

     12-07-2005 15:24:47

     12-07-2005 15:24:53

    I only need information with period of 3minutes!!!

    I thought build a DTS package with DataDriven Query.

    Anybody help me writing a ActiveX script for doing this???

    Thankx,

    Cláudia

    Regards,

    Cláudia Rego

    www.footballbesttips.com

  • November 8, 2005 at 8:59 am

    #602806

    Do you require just the last 3 minutes from the table? Also how often will you be running the package?

  • November 9, 2005 at 3:24 am

    #602979

    I only need run the package 1 time for each server.

    I need a sample of information with T=(+/-)3 minutes.

    For example:

    12-07-2005 15:23:05

    12-07-2005 15:26:xx

    12-07-2005 15:29:xx

    12-07-2005 15:32:xx

    Can you help me writing a script??

    Thanks, Cláudia

     

    Regards,

    Cláudia Rego

    www.footballbesttips.com

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

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