I am having a strange problem with the SSIS .
A simple insert from Source to destination is working perfectly. It gets me 19 rows into my destination.
The moment the SSIS package is running via SQL Job, its getting only 9 rows.
I have given all the level of user permission to the destination database and server but still the problem persists.
Any help will be appreciated.