Connecting to mainframe from SQL Server 2000

Hi,
I'm taking data from mainframe and processing it using SQL Server
2000. Now I take data from mainframe as .txt file and loading it to
the sql server 2000. How can I connect SQL Server 2000 to mainframe to
get the data.
Thanks
ShafeekOne way is to ftp the file to the distributed environment such as a Windows
file server or on the SQL Server box and then use DTS or Bulk insert/bcp
utilities.
"Shafeek Khalidh" <itsprobablyme@.msn.com> wrote in message
news:f086c89e.0307110827.5936d7bb@.posting.google.com...
> Hi,
> I'm taking data from mainframe and processing it using SQL Server
> 2000. Now I take data from mainframe as .txt file and loading it to
> the sql server 2000. How can I connect SQL Server 2000 to mainframe to
> get the data.
> Thanks
> Shafeek|||Why don't you try Extended Stored Procedure.
Because you can use C to write DLL, you can do almost anything in it.
Include connect to mainframe, and get some data, certianly you can put it
into server if you want.
cheers
"Shafeek Khalidh" <itsprobablyme@.msn.com> wrote in message
news:f086c89e.0307110827.5936d7bb@.posting.google.com...
> Hi,
> I'm taking data from mainframe and processing it using SQL Server
> 2000. Now I take data from mainframe as .txt file and loading it to
> the sql server 2000. How can I connect SQL Server 2000 to mainframe to
> get the data.
> Thanks
> Shafeek