SQL Server Performance

get modified date of .csv file

Discussion in 'SQL Server 2005 Integration Services' started by arkiboys, Jan 10, 2008.

  1. arkiboys Member

    Hi,
    the ssis package loops through a folder using a foreach loop container and imports the data inside each .csv file into the database.
    Now I would like to add the functionality to first check the modified date of the .csv file. If it is NOT today's date then the package should fail or go to error.
    Any thoughts how to do this please?
    Thanks
    arkiboys, Jan 10, 2008
    #2

  2. satya Moderator

    You could take help of CLR Procedures here, by writing a code in VB or .net to findout the modified date of source file, not sure you might check http://www.sqlis.com for more information.
    satya, Jan 10, 2008
    #3

  3. dineshasanka Moderator

    You can use SSIS script components
    I can send you a sample if you send me a mail to dineshasanka@gmail.com
    dineshasanka, Jan 15, 2008
    #4

  4. arkiboys Member

    Hi,
    If it is ok, please paste a copy here.
    Many thanks
    arkiboys, Jan 15, 2008
    #5

  5. dineshasanka Moderator

    I can't copy and paste here as I am going to send an sample SSIS pacakge for you. Send me the copy of the CSV as well if u wish to
    dineshasanka, Jan 15, 2008
    #6

Share This Page