execute SSIS from Ms Access

[neoklis]

Hi All,

I am trying to execute a deployed SSIS package, from Ms Access 2003. Is it possible;

thank you

 

[neoklis]

I manage to solve the problem by making a job and executing it from Access with sp_start_job. Is there a store procedure that can return the packages are currently running on SQL?

 

[SQL_Hell]

Good idea I was going to suggest this....but having a busy few days at the moment.

It's much better to run from job, that way you get the job history and you can always guarantee the SSIS runs under the correct user account.

In terms of checking whats running, look at the follwing tables

msdb.dbo.sysdtspackages90

msdb.dbo.sysjobactivity

 

[neoklis]

thank's a lot for your reply and your suggestions