Home > IT Answers > AS/400 > Import AS/400 files into SQL server
Yenyen
5 pts.
 Import AS/400 files into SQL server
AS/400 backup, AS/400 jobs, SQL Server 2005
Hi I would like to know how to create a job to transfer all the files (data) from AS/400 to SQL server 2005 (keep as backup)

Software/Hardware used:
ASKED: April 27, 2009  6:31 PM
UPDATED: May 1, 2009  8:42 PM
RELATED QUESTIONS
Answer Wiki:
Hi Yenyen If I remember correctly - and I never do. You need Client-Access installed on your server to get IBM's ODBC. You need to set-up an ODBC source on your server into the 400 In SQLServer make a DTS and schedule it. Phil
Last Wiki Answer Submitted:  April 27, 2009  8:56 pm  by  philpl1jb   44,630 pts.
All Answer Wiki Contributors:  philpl1jb   44,630 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You don’t have a tape drive?

Or you can save it to a *savf file and put that on the server for backup

RonKoontz
 1,780 pts.