Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

OLEDB Source Expression to call Stored procedure with 3 parameters in SSIS 2005 Expand / Collapse
Author
Message
Posted Friday, October 18, 2013 4:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 9, 2016 3:48 AM
Points: 112, Visits: 297
can you please tell me any one syntax for OLEDB Source Expression to call Stored procedure with 3 parameters in SSIS 2005

example: [Exec SPNAME and 3 parameters (para1, para2 and para3)]
Post #1506075
Posted Friday, October 18, 2013 5:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:43 AM
Points: 7,430, Visits: 18,001
Have a look here.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

Never attribute to malice that which is adequately explained by stupidity
Post #1506085
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse