RE: Moving a text file to a physical file

["Brian Piotrowski" <bpiotrowski@xxxxxxxxxxxxxxx>]

Hi Tom,

Moving the file through the MSSQL server is a piece of cake.  The big
problem I am having is trying to get the AS/400 to allow the SQL server
to access the text files on the IFS.

I haven't found an easy way to allow the DTS package on the SQL server
access the AS/400 file share.  Because you cannot simply access the
shared drive on the AS/400 (due to enhanced security), I can't have the
program run and grab the file.  It always fails with an "access denied"
error.

So the only other way I can think I can get around this is to transform
the data on the AS/400 and then import it through an ODBC connection on
the SQL Server.

Brian.

-----Original Message-----
From: qsrvbas@xxxxxxxxxxxx [mailto:qsrvbas@xxxxxxxxxxxx] 
Sent: Monday, January 09, 2006 2:13 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Moving a text file to a physical file

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