Import Mainframe Flat Files Data into SQL 2000 tables

#1

I have some flat files stored on mainframe tapes. How can I configure
the DTS in SQL2000 to get those files? What driver should I use?
These files are hugh (approx. 9GB). Is it possible to connect to those
files directly without FTPing into another machines before sending
into SQL?

Any additional information or web links would be greately appreciated.

Thank you very much.

#2

In article <aa434de4.0307011155.33ebf91d (AT) posting (DOT) google.com>, Chicagoan
<fungek_aa (AT) yahoo (DOT) com> writes

Quote:

I have some flat files stored on mainframe tapes. How can I configure
the DTS in SQL2000 to get those files? What driver should I use?
These files are hugh (approx. 9GB). Is it possible to connect to those
files directly without FTPing into another machines before sending
into SQL?

Any additional information or web links would be greately appreciated.

The files will need to be made available on a windows compatible file
system. If you cannot browse the files from Windows you cannot load a
file.

I believe some systems whilst file based still have ODBC or OLE-DB
providers. Sometimes you can use middle-ware that will do the job such
something by Cache I seem to recall, so this may be an option too. Try
contacting your system support provider

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

#3

I did this at a job a couple of years ago, but forgot the details. If I
recall correctly, the data was exported to text files, and I used something
called BCP, which is part of SQL Server, but it is command-line. It's a
whole lot faster than doing it through the GUI. So I guess my suggestion is
to do a search on BCP

"Chicagoan" <fungek_aa (AT) yahoo (DOT) com> wrote

Quote:

I have some flat files stored on mainframe tapes. How can I configure
the DTS in SQL2000 to get those files? What driver should I use?
These files are hugh (approx. 9GB). Is it possible to connect to those
files directly without FTPing into another machines before sending
into SQL?

Any additional information or web links would be greately appreciated.

Thank you very much.

#4

Darren Green <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in message

Quote:

The files will need to be made available on a windows compatible file
system. If you cannot browse the files from Windows you cannot load a
file.

I believe some systems whilst file based still have ODBC or OLE-DB
providers. Sometimes you can use middle-ware that will do the job such
something by Cache I seem to recall, so this may be an option too. Try
contacting your system support provider

Does it mean I CANNOT DTS the flat files, which are located on
mainframe, directly?

So the only way I can DTS flat files is to have those flat files
transfered from mainframe to a Windows-based computer. Is that
statement correct?

Thanks!

#5

In article <aa434de4.0307021232.33e177c8 (AT) posting (DOT) google.com>, Chicagoan
<fungek_aa (AT) yahoo (DOT) com> writes

Quote:

Darren Green <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in message
The files will need to be made available on a windows compatible file
system. If you cannot browse the files from Windows you cannot load a
file.

I believe some systems whilst file based still have ODBC or OLE-DB
providers. Sometimes you can use middle-ware that will do the job such
something by Cache I seem to recall, so this may be an option too. Try
contacting your system support provider

Does it mean I CANNOT DTS the flat files, which are located on
mainframe, directly?

Not unless the mainfame can present the files to the machine running DTS

as through is was any other windows file share.

Quote:

So the only way I can DTS flat files is to have those flat files
transfered from mainframe to a Windows-based computer. Is that
statement correct?

See above, but this would be the simplest method. Most systems will

support FTP, so when I had feeds from some old VMS systems, (dunno if
you class this as a mainframe or not). I would get the files ftp'd to a
suitable share which was actually another VMS VAX running DEC Pathworks,
so we could access them from DTS, but could also have been any windows
server for example.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

#6

In article <aa434de4.0307071147.4cae6034 (AT) posting (DOT) google.com>, Chicagoan
<fungek_aa (AT) yahoo (DOT) com> writes

Quote:

Thanks a lot for the clarification.

Other than FTP, I have also heard of XCOM which can also transfer to
file into a windows-based system.

I would like to know what are the difference between FTP adn XCOM?
When to choose FTP over XCOM and vice versa?

Thank you very much in advance.

Sorry I am not familiar with XCOM so have no idea when it may be more
appropriate.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Import Mainframe Flat Files Data into SQL 2000 tables

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Import Mainframe Flat Files Data into SQL 2000 tables - 07-01-2003 , 02:55 PM

Re: Import Mainframe Flat Files Data into SQL 2000 tables - 07-01-2003 , 04:31 PM

Re: Import Mainframe Flat Files Data into SQL 2000 tables - 07-02-2003 , 08:48 AM

Re: Import Mainframe Flat Files Data into SQL 2000 tables - 07-02-2003 , 03:32 PM

Re: Import Mainframe Flat Files Data into SQL 2000 tables - 07-05-2003 , 03:40 AM

Re: Import Mainframe Flat Files Data into SQL 2000 tables - 07-10-2003 , 02:58 PM