Thanks for the replies.

I have got the solution, I have to set trustworthy option on the DB so that stored procedures can execute the system objects programatically.

Thanks Again.

Thanks for your reply, sandor.

owner account which is used to create\trigger the job has admin access on the box(windows and sql server both).

If I disable this purticular execute task, rest...

No Proxy account used.

I am running it from the file itself. Is this a problem..?

package does not use any credentials other then in the connections which I am supplying through the configurations file.

Hi Carolyn & Charley,

I am facing a similar problem. The task works well while executing directly from BIDS. But when i am trying to run it through a Sql Server...

Hey,

I have recently implemented a similar SSIS package and have found out a very easy and effective way of running the VBA code from SSIS.

You can certainly built on .Net...

Thanks Alvin for your advice for a newbie.

here are the couple of methods I have implemented along with the issues I am facing:

-Created a Sql Agent job and scheduled it...