Q:

SSIS package runs fine but SQL Server job fails

I am having a package which is loading one of my table of database. When I run the SSIS package individually the package is running fine at first. But when I execute the job on SQL, the job fails & the database table records becomes empty.
After that the SSIS package also fails to run. The cause of job failure is giving primary key violation for that table. The package is simply importing the data to this table.

A:

can you be more specific? 
As I understood its not a SSIS package error, it seems to be a data issue.
I suggest checking if the package has any configuration assigned to it (right click the package on an empty area and select "pacakge configurations") because if it does, it ignores the hard coded values and overwrite them with the one on the config.

