Topic: SSIS - the Packet is successfully fulfilled but happened nothing
All greetings, at me as not .
Has been developed Workflow which without problems works in DEV and QA systems.
On PROD to system Workflow does not work, to be exact - after successful end of the process executable Job Agent, the DB does not contain anything. To put it briefly, the system considers "No news are good news".
About most Workflow.
- There is a loading of the data from several CSV-files in a database.
- On the basis of the loaded data, Workflow produces analytical calculations then n the amount CSV of documents, different statistical results is preempted.
I can not understand the reason on which in DEV and QA the arrived files become normally engrossed in reading and in PROD is not present.
And the most interesting that if some times to rename CSV documents SOMETIMES happens and all becomes engrossed in reading and fulfilled as it is required.
With old files which were used in due time for the first development, also there are no problems if them to give on in PROD. problems from executor Job who from file system reads out the data, in my understanding are not present.
On SSIS in the enterprise administrators help unfortunately could not also all that I found in the Internet on this subject, or the insufficient rights or incorrectly set . On it if who faced a such problem, share the decision if that exists.
All certainly thanks for the help in the decision!