I currently produce a data file on an AS400 for use in a SQL 2000 database.<BR><BR>I use the CPYTOIMPF command to produce a file from a query. I then copy it to a PC directory using the CPYTOPCD ...
If you haven't installed SQL Server 2014 Service Pack 1, keep it that way. If you have installed the service pack, you may be regretting it. Microsoft pulled it last week after install errors surfaced ...