execute a sql 2005 abc.dtsx file within a Job?

[DLu]

Hi:

How do i execute a sql 2005 abc.dtsx file package within a scheduled SQL Agent Job every 6 pm?

thanks
-D

[rmiao]

Choose SSIS package as step type and file system as package source when create job step in SSMS.

[DLu]

Hi RMIAO:

thank you very much for the help.
-D

[DLu]

with a click on the xxx.dtsx and execute:
The package run from myPC C:\ to prodSvr fine.
The package run from prodSvr C:\ to prodSvr fine.

But when run job from
1. myPC to execute this xxx.dtsx, job failed without specific error at all
2. prodSvr, not even accept the xxx.dtsx as step 1 with follow error
"the specified @subsystem is invalid. valid values are returned by sp_enum_sqlagent_subsystems. error 14234"

myPC is SQL STD 2005, the prodSvr with SQL 2005 Enterprise.
thanks
-D

[rmiao]

What's sql agent service account? Does it have permission to execute that file? Does the package use remote data source?