Unanswered: Loading data from Mainframe to SQL-server
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.
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.