RE: SYS21 - Re: SYS21 & SQL Server Extractions

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]

You may also want to try first deleting the records from the file and insert
the latest records (rather than an import) as a "SP".  This bypasses the DTS
and maintains the integrity of the initial database.


-----Original Message-----
From: Bill Pinnington [mailto:BPinnington@centura.co.uk]
Sent: Thursday, July 11, 2002 9:09 AM
To: 'jbausers-l@midrange.com'
Subject: RE: SYS21 - Re: SYS21 & SQL Server Extractions

Jon,

This may well be due to the account used by the SQL Service Agent.

Check the Microsoft website for article "How to Run a DTS Package as a
Scheduled Job (Q269074)"

If the security is fine, then check you have the latest service pack for
your version of client access.

I have had this problem before, and had to resort to scheduling the job
outside of SQL.  You can submit the DTSRun command in a batch file or direct
from a command line.  If you are still having problems then you may want to
set up an AS/400 user with the same name as the NT Account specified in the
SQL Service agent, as this is the profile it submits the job under (although
it should use the username and password in the Client Access Data Source in
the DTS Package.)......Let me know how you get on.

Hope that helps.

Thanks,
Bill Pinnington
Business Systems Analyst
Centura Foods Ltd.

-----Original Message-----
From: JonWadey@mst-ltd.co.uk [mailto:JonWadey@mst-ltd.co.uk]
Sent: 11 July 2002 13:57
To: jbausers-l@midrange.com
Subject: SYS21 - Re: SYS21 & SQL Server Extractions


This message has been successfully virus checked by the Centura Foods Mail
system.

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Using SQL Server 2000 Data Transformation Services (DTS) to extract data
from System21 into a SQL Server database, through the Client Access ODBC
driver.

The DTS Packages will successfully connect to the AS/400 and extract data.
 However, if the package is scheduled through the SQL Server Agent, it
fails immediately after connecting to the AS/400.

Has anyone had any similar problems with this type of setup?

TIA
_______________________________________________
This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
To post a message email: JBAUSERS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
or email: JBAUSERS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/jbausers-l.


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________


=======================================================
This email, its content and any files transmitted with it are confidential
and intended solely for the use of the individual(s) to whom it is
addressed.
If you are not the intended recipient, be advised that you have received
this email in error and that any use, dissemination, forwarding, printing,
or copying of this email is strictly prohibited.
This email, its contents and any files transmitted with it have been
prepared using information believed by the author to be reliable and
accurate, but Centura Foods Ltd. makes no warranty as to accuracy or
completeness. In particular Centura Foods Ltd. does not accept
responsibility for changes made to this email or related files after it was
sent. Any opinions expressed in this email and any related documents
are those of the author and do not necessarily reflect the opinions of
Centura Foods Ltd. or its associated companies.

If you have received this email in error please notify the Centura Foods
IT Helpdesk by telephone on +44 (0) 1606 830 533.
=======================================================


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
_______________________________________________
This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
To post a message email: JBAUSERS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
or email: JBAUSERS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/jbausers-l.