More than 10 times, i validated the package can be executed successfully, if i use a SQL job to run this package. All data and function goes well, however the job result reported failure after i saw the job 100% completed.
That 's so weird.
Anyone met the same the issue.
Could anyone give me some suggestion or hints
Debugged it frustrateed~~