Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS package with input parameter. Expand / Collapse
Author
Message
Posted Friday, August 20, 2010 7:37 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:18 PM
Points: 96, Visits: 347
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
Post #972520
Posted Friday, August 20, 2010 9:24 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:18 PM
Points: 96, Visits: 347
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.
Post #972623
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse