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

Tom,

If you want a vendor solution, perhaps you will want to consider ours.

If not, stop reading! :-)

If you want to download a file from your iSeries to your MSSQL Server, you
might want to consider our iSeries PC-Engine. It is economically priced and
of course, will do a whole lot more than just download data. There is no
tiered pricing (one price, regardless of the processor you are running on)
and there is also no annual maintenance fee.  Oh yeah...and once you
purchase it, you are automatically licensed to all new products we come out
with in the PC-Engine line as well as free software updates for the life of
that iSeries. No extra charge.  For example, we recently added a new product
to the PC-Engine, our PC-Engine Spool to PDF tool which allows you to
convert OS/400 Spooled files to PDF files and even email them from your
iSeries if you want. Both tools are included in the purchase price.

If you are interested, you can download a full function free trial version
at: http://www.turbogorilla-software.com

HTH

Luke Dalton
TurboGorilla-Software


 
-------------- 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. 
>