Connection to iSeries IBM fails when running SSIS package through a job

• Micha van der Ende

  Mr or Mrs. 500

  Points: 507

  More actions

  August 2, 2007 at 6:26 am

  #175683

  Hi,

  We have an ETL process running, which collects data from the IBM iSeries and Progress databases to put them into staging db's, but for some reason the SSIS package fails to connect to the external sources when we run it through a job.

  The strange thing is that when we run it within BDS in debug mode, it runs perfectly. I first thought that it could be a problem in the SQL Server agent account, but this is a domain administrator.

  We save the package to the MSDB db with the "Encrypt All Sensitive data with password" option. We tried every option, but without any positive result.

  Does anybody have a clue?

  Thanks in advance

  Micha

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  August 3, 2007 at 3:17 am

  #724429

  If you use a config file to set the passwords at run time, does that help?

  http://technet.microsoft.com/en-us/library/ms141747.aspx

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• Micha van der Ende

  Mr or Mrs. 500

  Points: 507

  More actions

  August 3, 2007 at 7:02 am

  #724483

  Thanks,

  We indeed solved the problem by using the config file.