Jon,

I would try to create DTS pacakge in DTS Designer, get it to work, save it as VB program and see what properties should be set.

>
>It could be that we are not defining the DataSource correctly - the folder in which the DBF tables reside:

>************************************
>FUNCTION AddSourceConnection
>************************************
>*
>* Add a source connection to the package
>*
>
>LOCAL oConnection AS DTS.Connection2
>
>oConnection = goPackage.Connections.New("VFPOLEDB")
>WITH oConnection
>	.Name = "Source Connection"
>	.ID = 1
>	.Reusable = .t.
>	.ConnectImmediate = .f.
>	.DataSource = "\\ServerName\SomeDir\"
>	.ConnectionTimeout = 60
>	.UseTrustedConnection = .f.
>	.UseDSL = .f.
>ENDWITH
>
>goPackage.Connections.Add(oConnection)
>RELEASE oConnection
>
>RETURN