Does anyone know a method for specifying the output file size from a DTS package?
I have a requirement to output data files in 64 Mb chunks from a DTS package.

In message <93236859.0403040617.7d3712e2 (AT) posting (DOT) google.com>, Alan
O'Gorman <alan.o'gorman (AT) sunlife (DOT) com> writes
There is nothing in DTS that will support this. You could restrict your
source to only provide 64MB worth of data at a time, and use a loop to
keep exporting until you have read all records, but this could get
messy.

Probably the simpler option would be to just write some code to break up
the file into chunks. No reason why this could not be done in an ActiveX
Script Task using VBScript.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org