importing data from as/400 to sql server 2005

Question

importing data from as/400 to sql server 2005

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

elonacaci SSC-Addicted Points: 495 More actions · Answer 1

HI,

Yes there is a dsn created for that name in the ODBC DATA Source Administrator and the name of the driver there is Client Access ODBC Driver(32 bit) while in the string connection when I schedule the job it is : Client Access Express ODBC data source;

But I think these must be the same

elonacaci SSC-Addicted Points: 495 More actions · Answer 2

It is really strange,because everything finishes successfully if I run the package from

SSMS/Integration Services under msdb.

It fails only when I run the job. But I need to run this job automatically!

dassy_man Newbie Points: 5 More actions · Answer 3

Hi. Did you manage to figure out how to solve this? I am experiencing a similar problem with my SSIS package extracting data from AS400 here in Spain.

Thanks