is partial export to xls possible 1

[btween]

I'm running into a problem when I'm trying to export a table in a SQL db.

The number of records have exceeded 16384 and I'm getting an error spreadsheet full.

Is there a way to do a partial export, sort of like a query saying export all records that have the date field greater than say 10/28/2004?

If this is not possible is there a way to have the export span across a couple of spreadsheets.

Ideally, I would prefer the first option but either way your help is much appreciated.

 

[JohnDTampaBay]

In the Transform Data Task for the export on the Source tab, modify and use the following code to pull a limited number of rows from your source table. Good luck!

SET ROWCOUNT 16384

SELECT * FROM SomeTable
WHERE DateField > '10/28/2004'

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[btween]

Thanks for that.

I actually ended up using the query builder because there was no transform tab on the source, but it worked regardless.