Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2011-08-06 : 16:41:19
|
| I have a data flow with oledb source (stored procedure that performs some operations one of them declare @id table (xxx) insert into it and at the end select * from @idThe stored procedure works fine but on putting this stored procedure as oledb data source in the data flowI am getting an error message [OLE DB Source [1]] Error: A rowset based on the SQL command was not returned by the OLE DB provider.sarah |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-08-06 : 16:53:56
|
| If you have multiple statements in the stored procedure, it may be that you need a SET NOCOUNT ON at the beginning of the procedure. See here. |
 |
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2011-08-06 : 17:31:59
|
| Thanks so so muchsarah |
|
|
|
|
|
|
oledb data source sp select from @id table