SSIS package not inserting records when run as Job

问题:

Hi I want to run my SSIS package as job. I have successfully created job and package. It runs without any error but it is not inserting records to the database.

But when I run the same package using DTEXECUI.EXE It is inserting records in the database. Please help.

回答1:

As discussed, it was discovered that the package was using Environment Variables as part of the connection manager, SQL Server/Agent/SSIS service needed to be restarted for these new variables to be picked up.