I am trying to use a stored procedure in the OLE DB source, I am using the SQL Command for the Data Access mode. It returns values when using the preview but when I test the package I receive the error, "A rowset based on the SQL command was not returned by the OLE DB provider."

how is theole db source configured?

For the the connection manager I just have a basic connection to the Sql server and then I am using the SQL command for the data access mode. The connection manager does work when I use other access modes like the table and view option.

how is the connection manager configured? you may need to use a different configuration.

ConnectionManagerType = OLEDBData Source = ABCSERVER;Initial Catalog=ABCDATABASE;Provider=SQLNCLI.1;OLE DB Services=-13;Integrated Security=SSPI;Auto Translate=True;DataSourceID = DelayValidation = FalseDescription = RetainSameConnection = FalseSupportsDTCTransactions = True

DustinT wrote:ConnectionManagerType = OLEDBData Source = ABCSERVER;Initial Catalog=ABCDATABASE;Provider=SQLNCLI.1;OLE DB Services=-13;Integrated Security=SSPI;Auto Translate=True;DataSourceID = DelayValidation = FalseDescription = RetainSameConnection = FalseSupportsDTCTransactions = Trueif i'm not mistaken, the sql native client provider (SQLNCLI.1) only works with sql server 2005. if you are using a different version of sql server, then try using the microsoft ole db provider for sql server (SQLOLEDB.1)

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=366077&SiteID=1

This old chestnut, just add "SET NOCOUNT ON" to the start of your SP (I assume it's an SP right?) yeah this always stuffs me up eh :) Cheers