Re: Kinda OT: Moving a flat file from AS400 to MSSQL Server via DTS

[vhamberg@xxxxxxxxxxx]

<vendor>

Consider going the other way - use our RPG2SQL product, which gives you 
real-time read/write capability to just about any ODBC-enabled database.

www.rjssoftware.com for info, or call 952.898.3038 and ask for me, Vern, or 
just for info on the product.

</vendor>

-------------- Original message -------------- 
From: "Brian Piotrowski" <bpiotrowski@xxxxxxxxxxxxxxx> 

> Hi All, 
> 
> 
> 
> Has anyone had any experience with transforming the data from within a 
> text file located on an AS400 to an MSSQL server? 
> 
> 
> 
> My MSSQL server keeps failing when it tries to retrieve the file. I 
> know it is because I cannot assign the username/password that runs the 
> DTS package. I have checked the AS/400 and set up the appropriate file 
> shares to allow a Windows system to access it. However, the AS/400 
> still requires a username and password to access the share. 
> 
> 
> 
> Any ideas? 
> 
> 
> 
> Thanks, 
> 
> 
> Brian. 
> 
> 
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=- 
> 
> Brian Piotrowski 
> 
> Specialist - I.T. 
> 
> Simcoe Parts Service, Inc. 
> 
> PH: 705-435-7814 
> 
> FX: 705-435-6746 
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=- 
> 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
>