run dts package from sql server agent

[tek2002]

i created a dts package called Nef_Projects which moves data from an excel file to table1 in BLA database - it works fine when executed.

i created a job in sql server agent with step1 deleting data from table1 in BLA database and step2 runs the above DTS package.

the problem i am having is that the job executes fine with no errors but table1 in BLA database is empty so step1 appears to work but it that seems step2 is not working.

perhaps my syntax in step2 is incorrrect?
master..xp_cmdshell 'DTSrun /BLA/sa/pwd123/Nef_Projects'

anyone have any suggestions?

thanks for your help.

 

[mkal]

No real solution but you might want to look at which account the job is running under. I know I've had DTS packages work fine when I execute them but fail as a job.

See the following:

http://support.microsoft.com/default.aspx?scid=kb;en-us;269074

Also, to use the xp_cmdshell you must have admin rights or assign the user account execute permissions.