Calling a SSIS package from Sql Server Stored Procedure and inturn call this SP from Ms Access VBA.

• rangu

  Default port

  Points: 1407

  More actions

  July 25, 2012 at 3:24 pm

  #261617

  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

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  July 25, 2012 at 5:01 pm

  #1517682

  Duplicate post. Please post all further responses here

  Please, do not cross post as it just fragments any responses you get from members.

• rangu

  Default port

  Points: 1407

  More actions

  July 25, 2012 at 5:09 pm

  #1517687

  Hi,

  I was just wondering to which thread does my question belong to MSAccess/Integration Services/General Sql Server?

  Hence psoted in 3 areas, aplogize for the inconvinience caused!!!