Afternoon all,

I am creating a DTS package that pulls data out of Pervasive and puts
it into SQL Server.

Normally, I would configure a DSN on the source (Pervasive) server and
use the DTS "Other Connection" GUI in conjunction with the Pervasive
ODBC Client Interface and the DSN I had previously created.

However, for this project, getting the DSN created on the servers
(especially the production server) is not going to be easy...in fact
almost impossible.

In the past, we've coded in the non-DTS enviroment, and have been able
to use a DSN-Less connection: "Driver={Pervasive ODBC Client
Interface};DBQ=@mydata;UID=;PWD=;ServerName=xxx"

I've looked all morning and have found very little on how to do this in
the DTS enviroment. Most of the posts indicated that this cannot be
done in DTS.

I just wanted to confirm that before I move on...

Thanks,

Steve