I am trying to create a DTS process that uses ftp to push data from a sql table to a remote site. I need to capture the last run date into a global variable and then use as a parameter in a query to ensure the data sent has no duplicates and contains all necessary rows.
When running as a scheduled job, is the global variable saved for the next execution. When I save the package in design-time, the value is captured and saved, but I am not sure about run-time.
Has anyone tried this before without the use of an external ini or sql table?
When running as a scheduled job, is the global variable saved for the next execution. When I save the package in design-time, the value is captured and saved, but I am not sure about run-time.
Has anyone tried this before without the use of an external ini or sql table?