June 21, 2015 at 4:50 pm
Hi
I have an SSIS package configured where the package will check the date of the excel file to ensure the modified date is todays date. Each time I run the package it changes the date to the current date and time. Is there a way to stop the package from changing the excel file before the script task can check the date of the file.
Basically the Excel file is generated by another process. This is done each day and I don't want to import the data into the SQL table if the modified date of the excel file is not todays date. We have had situations where the excel file is not generated and the data is duplicated in the SQL table.
Each time the current package is run, even without the script task the excel file is modified by the package. I just want the package to read the excel file not modify it.
Thanks in advance
Graeme
August 4, 2015 at 4:37 pm
Hi All
The way around this is to create a script package that performs the check of the Excel file modified date. If this check passes then this package will start another package that will perform your other tasks, i.e. the import of the data in the Excel sheet into your table. If the modified date is outside your parameters then this package will fail and not start the next package.
I hope this helps others
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply