Do you need administrater access to run this, because I haven't, and wont be able to get this access

because I need the job to be created, run and deleted automatically from as asp page

not sure if that would matter as the asp page calls the stored procedure, which sits on the same server as the dts. I toook your advice however and generated...

Ive used every combination and still no luck.

In the failed Job my command line reads DTSRun /S "(local)" /N "rm_vr_VDC101_Import" /W "0" /E

thanks a lot sreejith, I originally tried to use a cursor but got stuck when I coulnt figure out how to assign more than one variable from it. I'll try...

thanks ill give it a go and post my results