tag:blogger.com,1999:blog-7475258030496424805.post3833375770898623270..comments2023-12-09T17:18:27.019+10:00Comments on Aakash Sharma: Output Paramaters in OLE DB Command in SSISakshttp://www.blogger.com/profile/09451014998532491869noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7475258030496424805.post-46490730889708105872008-04-18T08:17:00.000+10:002008-04-18T08:17:00.000+10:00@vahehoo: yes, syntax is correct but still if you ...@vahehoo: yes, syntax is correct but still if you try you wont get the value mapped back to the output parameter from the stored procedureakshttps://www.blogger.com/profile/09451014998532491869noreply@blogger.comtag:blogger.com,1999:blog-7475258030496424805.post-88029288633901351582008-04-01T09:44:00.000+10:002008-04-01T09:44:00.000+10:00It seems like this works for some people, but not ...It seems like this works for some people, but not for others even if they configure the task correctly. I get errors whenever I include output parameters in the SQLStatement. Yes, I use the correct syntax, but SSIS is not only not returning values, it errs out. I have tried ADO.NET for a ConnType also, and that didn't work either.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7475258030496424805.post-15691779252945548432008-02-25T11:00:00.000+10:002008-02-25T11:00:00.000+10:00In order to map an output parameter to on in store...In order to map an output parameter to on in stored procedure you have to use : ? output. So, your SQLCommand property would look like this:<BR/><BR/>SPName ?, ? outputVahehttps://www.blogger.com/profile/13862403560325037915noreply@blogger.com