Post reply

Stored procedure in SSIS

  • June 9, 2008 at 5:03 am

    #125807

    i have created the stored procedure in database.

    now i want to execute the stored procedure in oledb transformation in dataflow task..i tried with that but the procedure is not executing correctly..

  • June 9, 2008 at 10:39 am

    #826200

    Is it giving you an error or just not running at all? Does it work in BIDS and only failing in SSIS?

  • June 9, 2008 at 11:00 pm

    #826441

    actually its executing correctly and giving me the correct answer when i executed in sqlserver management studio..but its not giving me the correct answer when i executed in SSIS..i wrote one stored procedure ,in that procedure im passing two values ,using that two values im checking one condition..in ssis the condition s not checked and the whole table s getting selected ..but when i run it in sqlserver management studio its working fine..

  • June 9, 2008 at 11:23 pm

    #826443

    Hi why cant you try "Execute SQL" transformation instead?

  • June 9, 2008 at 11:47 pm

    #826448

    its control flow task know...i want to store the result in destination table..that can be done in dataflow only know..

  • June 10, 2008 at 6:58 am

    #826595

    It sounds like the values you are trying to pass to the SP in the package are not making it there. When you have the package open in BIDS, does run correctly there?

  • June 10, 2008 at 7:45 am

    #826644

    Did you try to use Execute SQL Task (under Control Flow item) to execute your SP? It works for me.

    --------------------------------------------------------------
    DBA or SQL Programmer? Who Knows. :unsure:

  • June 10, 2008 at 7:56 am

    #826655

    Tamilselvam.M (6/9/2008)

    its control flow task know...i want to store the result in destination table..that can be done in dataflow only know..

    You could make a slight modification to the SP and have it put the results in the destination table rather than relying on an SSIS package to do what you are trying to accomplish. Then, you can simply call the SP in a job rather than having to mess with SSIS.

  • June 17, 2008 at 8:13 am

    #829802

    this should help

    http://blogs.conchango.com/jamiethomson/archive/2006/12/20/SSIS_3A00_-Using-stored-procedures-inside-an-OLE-DB-Source-component.aspx

    A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.

    -Douglas Adams

Viewing 9 posts - 1 through 8 (of 8 total)

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