David -
The name of the book was either DTS Programming or SQL Server 2000 DTS Programming. It
is a red Wrox book. Aren't all the
Wrox books red? :-) I found it a Barnes & Noble in the SQL section. More than 99% of
us want to know about DTS. So it
should answer your questions.
I think the Network Admin tool you want is a 'sniffer'. I think you need a NA to
understand what you see.
If click on Import or Export in SQL Server 2000, then a Wizard walks you through
creating a simple DTS package.
Programming in DTS is iconic. Each icon is some VB code. Optionally, you can click
into that code. If you know VB, you
could change it. I would defer to that book about any API for DTS.
hth
-brian
David Cummins wrote:
> I do recall that it took a few minutes to transfer 120,000 records via DTS over
> ADSL, but I appreciate that the scientific approach might be in order. Choose
> easily compressed data (i.e. all the same) and do the doubling thing.
>
> Do you recall the name of the book? Another thing on the wishlist would be if
> the book had information on the DTS file format, because the Enterprise Manager
> interface leaves a lot to be desired...
>
> Unfortunately we're fresh out of Network Admins right now, so I guess that
> option is out then. ;)
>
> Is DTS implemented in VB, or is there just some sort of API for it? Where would
> one find the source?
>
> Cheers,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
