Hi Rowan

Thanks for your response,

I have no issues in connecting the SQL Server Db from VBA, I have done that part by connecting through a DSN setupn on my machine.

I could execute few other SQl Procs from VBA.

My challenge here is to run the SSIS package throguh a SP.

I need complete syntax for the SP to call the job already created. When I run the command above its just returning 0, means success..

he actual time for the SSIS package to run is 3.00 Mins

I need a Proc which tells whether the SSIS Job has been run completely and successfully.

Please suggest. If the full SP is created, ican call this from Access VBA with ease.

Thanks

Srini