Executing SSIS Package containing Update Stmts as a Job

I have an SSIS package containing an SQL Task that performs a table update based on values from a defined variable.

When executed directly from SSIS the package, the package executes successfully but when scheduled as a job, it fails at the update statement.

The job executes successfully when the sql statements are changed to either a delete or an insert

Has anyone come across this ?

[393 byte] By [Ify] at [2007-12-16]

# 1

Has anyone scheduled an SSIS package that contains an update statement within a sql execute task, as a job yet?

Ify at 2007-9-9 >

SQL Server Hot Topic