RE: Moving a text file to a physical file

[qsrvbas@xxxxxxxxxxxx]

midrange-l-request@xxxxxxxxxxxx wrote:

>   3. Moving a text file to a physical file (Brian Piotrowski)
>
>Is there an easy way to transfer delimited text from a text file that
>resides on the AS/400 to a PF?  I have a semi-colon delimited file that
>is downloaded from an external source and placed on our AS/400.  Since
>I'm having trouble moving this text file from the AS/400 to our SQL
>server, I think the other way I can move the data is to transfer it to
>an intermediary table on the AS/400 and then on to the MSSQL server.
>
>Is there a painless way of moving delimited text to a PF?


Brian:

I'm curious about whether or not a delimited file can be imported into SQL 
Server at all. If you had a similar file on your SQL Server system, would you 
be able to do it?

It seems odd that there is no MS support for this, so I'm surprised you can't 
just use whatever MS provides and import through a network drive.

Tom Liotta