Post reply

use store procedur in export\import wizard

  • November 8, 2011 at 3:04 am

    #247476

    hello.

    I want use a store procedure with input parameters in export\import wizard and save this in ssis for use other time,how to exec procedure in export\import wizard? and then how to execute this ssis for execute procedure with input parameter with T-Sql?

    please help me.thanks

  • November 8, 2011 at 6:37 am

    #1404474

    elham_azizi_62 (11/8/2011)

    hello.

    I want use a store procedure with input parameters in export\import wizard and save this in ssis for use other time,how to exec procedure in export\import wizard? and then how to execute this ssis for execute procedure with input parameter with T-Sql?

    please help me.thanks

    Re-ordered of operations 😉

    Create 1 SSIS package & include all Export / Import tasks you want to perform (including SPs).

  • November 8, 2011 at 10:12 pm

    #1404953

    i want create ssis from export\import wizard not from business inteligence,how to pass input parameter to stor procedure dynamically?

  • November 8, 2011 at 11:51 pm

    #1404978

    Create a package using the import/export wizard, do not run it but save it.

    Then open it with BIDS and modify it as you want it to be.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 3 (of 3 total)

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