Home Forums SQL Server 2005 Business Intelligence Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS) RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

  • June 12, 2013 at 12:31 pm

    #1623467

    Jeff Moden (6/12/2013)

    opc.three (6/12/2013)

    sneumersky (6/12/2013)

    Can SQL_Enthusiast's issue be solved with a WMI task or data reader? I have not used it in ages, nor am I a WQL expert 🙁

    A WMI Data Reader, maybe, since you can issue an "select" from the file system and the WQL supports the order by. I'll try it out and post back. Would that qualify as "native" SSIS for you Jeff since there is a "WMI Data Reader Task" built into SSIS?

    If it works correctly, it doesn't matter if it's "native" SSIS or not.

    Well, you pointing out using a Script Task as SSIS "needing a little help" seemed to imply that you were drawing a parallel between T-SQL needing xp_cmdshell to accomplish certain things non-natively, and SSIS needing .NET to do the same, but that parallel cannot be drawn.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato