DTS Run Via Job - Bypass Prompts

[OrWolf]

I have a DTS package with an active X script to prompt the user to update a start and end date. I'd like to be able to run the same package using a SQL job and accept the default values. Is it possible in the Active X to determine if it's being run via a job? That way if it's running via a scheduled job it will accept the defaults set by code otherwise prompt the user to confirm. Any suggestions would be appreciated.

 

[SajidAttar]

Create One more DTS Package with Dynamic Properties Task Through this DTS Packge update the Properties of your DTS Package.

Run this new DTS Package as First Step in you job, and modify ActiveX script of your existing DTS Package to Read values from Users if value is missing.

I hope this trick will work for you . . . some one else may have better solution, till then try this.



Regards,


"There are no secrets to success. It is the result of preparation, hard work, and learning from failure." -- Colin Powell