Post reply

IMPORT LATEST FILE using wql

  • January 12, 2009 at 5:51 am

    #126833

    hi all

    I need to import the latest file from the folder using windows query language in WMI .Is there any function for identifying the latest file in WQL .....

    Please help me out !!!!

    thanx in advance

  • January 12, 2009 at 11:58 am

    #925463

    Try downloading the File Properties task from http://www.pragmaticworks.com/FilePropertiesTask.htm which will get you the file details to calulate the latest file.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • January 12, 2009 at 7:57 pm

    #925645

    thanks for your idea ...but we are suppose to use only the options and components available in ssis.so i could not make use of the file properties task....... Please help me out for any other way for my problem.

  • January 13, 2009 at 2:58 am

    #925729

    Can you use a script task?

    If so, you can put the filename into a variable and then process it.

    There may be an easier way, but script will work for sure.

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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