Can I call my package from Store Proc

  • Hi,

    I am a new comer in SSIS.

    Can you tell me how do I call/run my package from store proc?  how? please give me a sample

    Assume  I have a package call " ImportBP.dtsx"

    some users mention about dtexec or xpPcmdshell... but I am still confused here.

    because it seems this method is running on cmd...

    I am thinking if I can run the package from store proc then I can use Reporting to call this store proc and presented to end user.

     

    anyway can help me?

     

    thanks,

    Susan  

     

  • The way I do it from a stored procedure is calling xp_cmdshell, then using the "dtexec" command to call the package.  It works pretty well, but I'm guessing there might be alternative ways if you don't want to go the stored procedure route (vb.net or c# code).

    But, if I understand you correctly, you want user to run the stored procedure, then the data will be displayed to an end user?  If my understanding is correct, I don't think I'd recommend this.  I think DTS / SSIS is great for running tasks asynchronously / through sql agent, but I wouldn't use it for on-demand data.  That's just my opinion... it's usually too time-intensive, especially when most users demand their data in under a second.  If you want more info about dtexec & xp_cmdshell, books online is a good place to start.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply