SSIS package with input parameter.

• ekant_alone

  SSCrazy

  Points: 2423

  More actions

  August 20, 2010 at 7:37 am

  #148453

  Hello,

  First of all thank you for this wonderful forum and discussions.

  Well,I am kind of in a situation where i need to update a working SSIS package. I need to provide an input parameter for the query working under data flow (OLEDB Source - SQL Command Data Access mode).

  Yes , i can do it in SQL execution task but i am not supposed to change the overall structure.

  I need an input parameter for the execution of this package /query.

  Really looking forward to hear some cool solutions.

  Thank you

• ekant_alone

  SSCrazy

  Points: 2423

  More actions

  August 20, 2010 at 9:24 am

  #1209744

  Hello people

  I got the solution. In case you are interested these two web links were pf great help.

  http://geekswithblogs.net/stun/archive/2009/03/05/mapping-stored-procedure-parameters-in-ssis-ole-db-source-editor.aspx

  http://sqlserversolutions.blogspot.com/2008/10/prompting-for-parameter-in-ssis.html

  Thank you all.