?
Solved

DTS hangs when transfering data from AS/400

Posted on 2003-11-17
10
Medium Priority
?
375 Views
Last Modified: 2008-03-06
We have some DTS packages that hang when trying to transfer information from an AS/400. They work when executed from the developer's machine (i.e. Open Package and Execute Package), but hang when scheduled to run on the server. We have the package set to be single threaded (number of parallel tasks set to 1) and we set On Success Workflow to do the Transform Data tasks one after another.

We are using IBM's Client Access for ODBC to connect (Version 8.00.02 and a newer version, 8.00.47 I think, on one server). We have the problem with more than one AS/400 and on more than one SQL Server 2000. But we have other DTS packages that work fine.

Something must be misconfigured somewhere, but we can't find it. Any ideas?
0
Comment
Question by:helt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
10 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 9767809
>>We are using IBM's Client Access for ODBC to connect<<
And they are installed on the server?

Anthony
0
 
LVL 1

Author Comment

by:helt
ID: 9767851
The development server has the whole Client Access package and I believe is the same version as the developer's machines.
The new production server had just the Client Access ODBC Drivers installed and it has the newer version. Our infrastructure admin. is going to install the whole package to see if it makes any difference. The development server used to work, but doesn't anymore. We don't know what changed. It is actually my boss who wrote these DTS packages, so I'm working a bit second hand here.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 9768079
Hopefully someone has some helpful ideas, but keep us posted.

Anthony
0
Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

 
LVL 34

Expert Comment

by:arbert
ID: 9769109
How do you have DTS connecting to the AS400?  OLEDB for ODBC Drivers?  Linked server?
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 9771173
Log in as the SQL Server agent and run your DTS and see if it works.

When you schedule a package it runs as the SQL Server agent login. When you run it manually on the developer machine it uses whatever you've logged in as.
0
 
LVL 1

Author Comment

by:helt
ID: 9771847
In the DTS Package, Other(ODBC Data Source) is selected as the Data Source and the System DSN entered is for a Client Access ODBC Driver. The user and password are entered in DTS. I do know that DTS uses the DSN's on the machine it is ran on, but we have compared the DSN's and cannot find any differences.

We will try logging in as the account the SQL Server agent runs under and try running the package. I'll let you know the results.
0
 
LVL 1

Author Comment

by:helt
ID: 10012182
I don't know if we've really fixed the problem, but it appears the going back to an older version of the Client Access package seems to have fixed the problem. It also seems sensitive to the version of software on the AS/400. I think there a bug in the software, but since I'm dealing with the interaction of Microsoft and IBM, I think we are out of luck.
0
 
LVL 34

Expert Comment

by:arbert
ID: 10012361
Ya, that is weird.  Usually, it was the older versions of Client Access that didn't like to do any kind of "non-ibm" communication and upgrading fixed it......Glad it's working though!

Brett
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11533476
PAQed, with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question