rangu (7/25/2012)

---

Hi,

I have a SSIS package which imports data from a source excel to the Sql Server database.

I want this package to be triggered from Ms Access form button event.

For this I have created a job and calling this job from a store proc, which has to be executed from button event.

Am using following in my SP

EXEC msdb.dbo.sp_start_job N'SSIS_FFIEC101';

Not sure if this is correct!

My requirement is:

TO create a SP which executes the job and this SP has to be called from MS Access.

I here also want to know whether the job has been executed completely.

Any other suggestions, pls let me know.

Any ideas pls help.

Thanks,

Srini