Tim,
You can create DTS packages via OLE Automation. The object model can be found (I believe) in the BOL.

While this may not help you now, SS 2000 DTS Designer has an export to VB. After you design the template, you can export it to VB, modify all the properties you want in code and run it from VB. Because object manipulation syntax is very similar in VB and VFP, you wouldn't have any trouble converting it.

Unfortunately, this type of export is only available in SS2000 but I just thought I would mention it, just in case.

>This is a one time operation for any of our clients who are moving to SQL
>Server backend from a native VFP environment.
>The tables already exist in SQL7, but are empty.
>For these clients, the files are large (1GB+ aggregate)
>
>I've used the DTS wizard to at least create a DTS package. But then I have to go
>into each work flow diagram and select the table lock option so that the
>package does not create any transaction logs . . . there are 100+ tables.
>
>Also, over time, the structures of both databases will change.
>The structure of some of the SQL tables differ from those in VFP (mostly
>that a identity field has been added) So I would have to continually
>recreate this huge package every time there is a structure update.
>Is there a way I can create a package programmatically?
>
>What is the fastest way to do this?
>Or should I say there another way to do this?
>
>Any help would be GREATLY appreciated!
>
>Thanks in advance,
>Tim
>
>(NT4 SP6 / SQL7 SP3)