Hi,

I'm trying to write some VFP code that will automate the transfer of large VFP tables (several million recs) into SQL Server 7. Both the BULK INSERT and BCP command line options are out since (as I understand it) these require text files and the overhead of creating the text file (both time and space) from dbfs is too heavy. Also anything like creating a remote view and appending data followed by a tableupdate() is no good since all these transactions would be logged (slowing the process down).
I have found some example code which uses DTS packages (the same backend as used by the import wizard in SQL 7).
The code goes along the lines of:

oPackage = CREATEOBJECT('DTS.Package')

*--Package description
oPackage.Name = 'DTS Test1'
oPackage.Description = "My first test"

oConnection.DataSource = "mydsn"

Where mydsn is the name of a system DSN. However I want to be able to connect through ideally a connection string, or second best a file dsn - so the user doesn't have to setup there own system DSNs every time.

I'm stuck as it only seems to like system DSNs. Any help would be very much appreciated.

Thanks,
Ian.