SSIS package with input parameter.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS package with input parameter.

SSIS package with input parameter.

Rate Topic

Display Mode

Topic Options

Author

Message

ekant_alone

Posted Friday, August 20, 2010 7:37 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:23 AM
Points: 88, Visits: 290

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

ekant_alone

Posted Friday, August 20, 2010 9:24 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:23 AM
Points: 88, Visits: 290

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 »

Permissions