Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Unanswered: Loading data from Mainframe to SQL-server

    Hi,

    Presently I am working in a data-conversion project where we are processing data in mainframe and then doing FTP into our local PC and then thru DTS package, loading into SQL-server tables. Is there any way so that we can load data directly from mainframe to SQL-server database bypassing all FTP and DTS package creations.


    Thanks in advance.
    Manabendra.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    There are many ways, but each has costs and benefits... It depends quite a bit on what kind of connectivity exists between the SQL Server and the mainframe.

    In the best case, you can import the data directly using SQL Server's BULK INSERT command. This assumes that you can see files on the mainframe directly (ala NFS).

    In the worst case, you can design DTS packages that will copy the files from the mainframe to your NT server (using an FTP or executable task), load the data from the NT file into the SQL Server, then delete the NT file.

    There are a number of steps between the best and worst cases, but they depend on what communications facilities you've got between the mainframe and your SQL Server.

    -PatP

  3. #3
    Join Date
    Sep 2004
    Posts
    2

    Smile

    Thanks for your input, aithough we are doing BULK INSERT.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Glad you've found a solution!

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •