EnsLib.SQL.Snapshot - Limitation of RowCount???
We are trying to convert some of our SQL Service Integration Service jobs from Visual Studio to Ensemble. If we execute a Stored Procedure within SQL Server Management Studio it is returning approx 12,000 rows. However when Ensemble executes the same Stored Procedure it is only returning 250 rows.
Is there a limitation to EnsLib.SQL.Snapshot?
This is how we are calling the Stored procedure
{
Set SPQuery = "{ ?= call dbo.usp_Interface_Ens_Select_PER355MC()}"
s parm=1
s parm(1,"SqlType")=$$$SQLVARCHAR
s parm(1,"IOTypes")=$$$SQLPARAMOUTPUT
set tSC = ..Adapter.ExecuteProcedureParmArray(.SelectPER355MC,.output,SPQuery,"oi",.parm)
if tSC = 1
{
set pResponse = SelectPER355MC.GetAt(1)
}
Quit tSC
}
Thanks
Scott