Post reply

how to execute the stored procedure in OLEDB source

  • February 23, 2011 at 6:23 am

    #147146

    how to execute the stored procedure in OLEDB source

    for example

    create procedure extractdata

    @contactid int

    as

    select firstname,middlename,lastname from Person.Contact

  • February 23, 2011 at 8:02 am

    #1290418

    Are you trying to output @contactid?

    Generally, using stored procedures within an SSIS package is a very, very, very poor idea. However, since it is a source, it will need the input parameter @contactid, which will need to be set somehow (through a variable or whatever). Once the input parameter is set (if that is what you are trying to accomplish) then execute the source from a SQL command using T-SQL (EXECUTE extractdata). Using an OLEDB Source adapter might be easier.

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

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