Hello all, I have a SSIS package that is importing data from a DB2 database. I am using SSRS (BIDS/VS2005). I want to be able to access the last time a particular package ran in my report, like in the footer of the page. I have found the globals.executiontime for grabbing the time the report was ran.
I want to do the same thing, except I want to call the date/time the last import was made to the database. Is there some easy way to grab that from SSIS, or will I need to maybe reference the DB creation time? (The database is dropped and recreated (for now anyway) in the SSIS package.)
The logging would provide this information, but might not be the best solution in your case, since you are dropping and recreating the DB from the package. I'd suggest that you add an Exec SQL task to your package that inserts (or updates) a table in your database with the package name and execution time.