Re: Looking for suggestions on a data transfer automation

Depends on how clean the data is. If it is very clean I would use a SQL
Server DTS and let that grab the data. Runs automatically and simple to do.
The new 2005 version is more powerful but more complex.

If there is a lot of transform going on I would use Scott's JDBC4 service
program and connect directly to the SQL Server data base and insert your
reocrds. Basically gives you more control over what is going on and driven
from the AS/400 side.

My basic problem with DTS is that they are invisible. Something happens but
you don't know what and people forget they are there and if they fail you
don't know about it but they are a powerful tool.

On Fri, May 15, 2009 at 10:33 AM, Valerio Vincenti <
vvincenti@xxxxxxxxxxxxxxxxxx> wrote:

I have a Client Access data transfer that grabs a DB2 file on the 400 and
creates a .CSV file on a MS SQL server sitting on our network (overwriting
the existing file).
I manually run the data transfer from a PC connected to the 400 which has
the target SQL server mapped to it.

I need to automate this process but I'm not sure whether I should be
looking at FTP or Remote Commands or other.

Thanks for any help!

Valerio Vincenti
IT Business Analyst
County of Spotsylvania, I.S. Department
Spotsylvania, VA 22553
Phone (540) 507-7507
Fax (540) 582-9841
e-mail: vvincenti@xxxxxxxxxxxxxxxxxx
--
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.