ADO - vbScript limiting records in the recordset

[TroyMcClure72]

I've created an ADO connection within DTS using vbScript ... can I limit the number of records returned?

I've tried using MaxRecords but it doesn't like it!

If Not isNull(recSQL(5).Value) then
connDW.MaxRecords = recSQL(5).Value
End IF

connDW.Open = "DSN=" & recSQL(2).value & ";Uid=*******;Pwd=******;

 

[SQLDenis]

use top in your select statement

select top 5 * from publishers

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[TroyMcClure72]

Sorry should have said, db i'm using doesn't accept TOP !!!!

 

[SQLDenis]

how about set rowcount? what DB are you using?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/