SQL Server : SSIS - Package Issue not inserting data

If I run my package in Visual Studio it successfully inserts all the records in table

but when I scheduled it as a JOB, it shows its running but doesn't insert any record in table.

C开发者_运维百科an anyone please advise

Regards

1. Try to Check first if your JOB on sql server executes successful to test it :

   right click on your job > Start Job at Step....

2. Then view its history...i assumed that there will be an error there thats why its not inserting new record.

3. Check your Connectionstring on your source and destination table if its correct.

4. You can also add Protection Level of your Packages

Regards

Sounds like it is a security issue. Under what context are you running the job? What exactly does the job do?

Most likely your SQL Server Agent service account does not have the proper permissions to do what your SSIS package needs. Grant the necessary rights and try again to start the job.

Edit: your job package seems like its a very different version. Can you give us some version numbers?