Hi give me the answer for stored procedure used in msbi

For what purpose do you want to call the stored procedure? Does it do something or return data to a dataflow? Chuck

Hi Suresh, You can use Execute SQL Task for this alternatively you can use a OLEDB Source in DFT here is how (http://geekswithblogs.net/stun/archive/2009/03/05/mapping-stored-procedure-parameters-in-ssis-ole-db-source-editor.aspx) Hope this helps. HTH, Cheers!! Ashish Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.

Suresh, Like Chuck (oldjeep) said, your question is vague. There are, not one, but multiple ways of calling an SP in SSIS. DFT source, Exec SQL tasks, script tasks. So the answer would depend on your requirement.Please mark as answer if this answers your question. Please mark as helpful if you found this post was helpful.

Suresh, Like Chuck (oldjeep) said, your question is vague. There are, not one, but multiple ways of calling an SP in SSIS. DFT source, Exec SQL tasks, script tasks. So the answer would depend on your requirement.Please mark as answer if this answers your question. Please mark as helpful if you found this post was helpful.