> 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.
>

"Allan Mitchell" wrote:

> 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
>
> > 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.
> >
>
>