Hi swede,

you may want to visit below site. but the solution is applicable for MSSQL 2000.

http://www.developerdotstar.com/community/node/503

Regards,

Renan A.

Thanks Ramesh, for the answer.

Hi Greg, thanks as well for additional input. That's what we are currently doing.

Regards, Renan

Thanks karthikeyan ,

i tried sp_depends and it returned list of table and Columns of retrieved table. but the list of table seems incomplete.

does sp_depends return only those tables...

Thanks Janine.

Yes under SA account since in our prod all jobs are owned by this account.

regards,

Renan.

Thanks for your replies.

Anyways, I just did a work around since we really need to have our report posted. I added another Execute Process Task that calls a separate...

It's accessible, Jo. I have tried to run MyExe manually, and it renames and posts the report to FTP server.

Also, the new drive is on the same machine....

Thanks Jo. yes, its LocalMachine.

But FYI, not all scheduled jobs behave like this. Only few of them.

Here's a little background of our DTS Package. May be it'll help......

thanks pmohan and Ambuj Mathur.

Please correct me if I'm wrong, I believe backup contains the entire database. Can I restore selected tables only?

thanks to both of you for the info.

currently, i've tried creating logs using scheduled job. and it's ok.

i'll just combine it with an *.exe we already have that automatically...