How can I use dts to transfer data back and forth between a text file on a
Unisys mainframe and a table in SQL server? How do I set it up?

I checked out the bulk insert reference, but if I went that route, what
would be the syntax? Paramter references such as "from datafile" doesn't tell
me much.

thanks for any help.

Hello David,

Can you not FTP the file down from the mainframe to a local directory?

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

thanks for replying.
I wouldn't have a problem with that. That's what I've done with other ftp
processes that pull down from an ftp server. My problem is finding an ftp
class to place within an application that will pull from the mainframe
(rather than an ftp server). They currently have an old DOS application here
that makes an external call to an ftp.exe to do the job. I am trying to bring
the process within the app (or database) w/o relying on an external app.


"Allan Mitchell" wrote: