I'm working with Variables in the SSIS for the first time. I managed to get The Minimum Date (Variable StartDate) and The Maximum Date (Variable EndDate) from the Source Database Table. (Pic below the 1st Execute SQL Task | Get Start Date And End
Then I want to delete records from the Destination Database Table based on the StartDate and EndDate Variable carried over from the 1st Execute SQL Task.
I debugged the package on the 2nd Execute SQL Task and I watched the variables carry over the date value that I expected.
(please note the AS DateTime inside the Enter SQL Query Dialog Box should not be there I fixed this on my end)
Once the debugger step into the 2nd Execute SQL Task everything run fine but the delete doesn't happen on the database!
I appreciate any help on this.
View Complete Post