I just inherited a ssis package. one of the variable is calling itself.. so the DALIC is always failing. It scheduled daily in the morning around 7 am est . I fixed it now.
The problem is before I notice that, I deployed to the server in the afternoon. and test ran it.. It succussed!! Then I didn’t do anything, but next morning it failed again?
Why is that?
Please advise me why the time frame can effect package failure thing?enter image description here
Tried: This package just send table to flat file. It does nothing else.. the date is set by a stored procedure, which basically just tell today’s date.
Dino is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1