Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

I have around 6+ years of experience in SQL Server development and in Business Intelligence area. I am working as Datawarehouse developer. My blog space includes all technical areas related to SQL Server and MSBI (SSIS, SSRS and SSAS).
Browse by Tags · View All
SSIS 7
xml 3
dynamic 3
Union All 3
SSRS 2
Data flow task 2
Buffer 2
Time 2
Date 2
varchar(max) 1

Archive · View All
February 2013 3
September 2009 3
June 2013 2
January 2013 2
November 2012 2
July 2012 2
July 2009 2
April 2013 1
December 2012 1
February 2010 1

SSIS rowset error

Feb 21 2013 12:00AM by Divya Agrawal Shah   

Recently, i encounted an error  on OLEDB Source  "Error: A rowset based on the SQL command was not returned by the OLE DB provider."

The OLEDB Source in the Data Flow Task was using an SQL command. The command query was executing a stored procedure. I was trying to export the data to Text file. The package was quite simple, however it was failing with the error    " A rowset based on the SQL command was not returned by the OLE DB provider."
After looking at many places, found that the stored procedure was missing "SET NOCOUNT ON". As soon as i added it, the DFT started working.
Whenever we are calling any procedure inside DFT, we need to make sure we have SET NOCOUNT ON. So, now designing any procedure always keep the set  as:

SET NOCOUNT ON
------CODE-------
SET NOCOUNT OFF





Tags: SSIS, rowset, Sql command, OLE DB, Set nocount on


Divya Agrawal Shah
89 · 2% · 629
2
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

3  Comments  

  • HI Divya,

    I have taken OLEDB Source, in that i have written EXEC TESTSP in Sql command and simply loading into one Flat file. But for me its not giving any errors. The package is executing successfully and loading data as well.

    Code:

    CREATE PROCEDURE TESTSP1

    AS

    BEGIN

    SET NOCOUNT OFF;

    SELECT * FROM dbo.Books

    END

    GO

    Thanks for sharing your thoughts.

    commented on Feb 21 2013 4:49AM
    Bala Krishna
    84 · 2% · 676
  • I think this error occurs, when you have multiple select, insert , update statements inside the procedure.

    commented on Feb 22 2013 2:24AM
    Divya Agrawal Shah
    89 · 2% · 629
  • Thanks for your reply.

    commented on Feb 22 2013 4:28AM
    Bala Krishna
    84 · 2% · 676

Your Comment


Sign Up or Login to post a comment.

"SSIS rowset error" rated 5 out of 5 by 2 readers
SSIS rowset error , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]