Error when importing data from AS/400 - appeared after SP1

I cannot transfer a list of tables from AS/400 to SQL 2005, in SQL Server
Import and Export Wizard.
This is what happends:
In SQL server Import and Export wizard, I choose IBM AS400 OLE DB Provider,
with Properties:
Data Source: (IP adress of my AS/400)
User name, password: (My username/password on AS/400)
Default Collection: (library on AS/400)
Then I choose destination database, and Next, it starts transfering list of
tables . After a few seconds I get this error:
'IBMDA400.DataSource.1' failed with no error message available, result code:
E_INVALIDARG (0x80070057)
Additional Information:
'IBMDA400.DataSource.1' failed with no error message available, result code:
E_INVALIDARG (0x80070057). (System.Data)
Error appeared shortly after installation of SP1, so I suspect of SP1
(although I am not yet sure) . Error happends always, nevermind the number
of tables in library.
This is important error for us because we cannot do transfer from AS400 at
all.I have gotten the same error and I was wondering if you had found an
answer to this problem?
*** Sent via Developersdex http://www.codecomments.com ***sql

error running SSIS Package from management studio

Hi

I created SSIS Package to transfer tables from one sql2005 DB to another sql2005 DB.

When I execute the package from the BIDS it execute succesfully.

However, when I import the package (file system) to the management studio - msdb - stored packages and run the package from there (right click: Run Package) I get this error:

the validate method on the task failed, and returned error code. the validate method must succeed and indicate the result using an out parameter.

what is the reason for this error?

I aprriciate your help.

SeoAndSo.com

Enable logging and see what are the validations failed. Probably it will be database connections you are using.

Thanks

|||

Thanks for your answer.

I enabled login and got this error now:

Code Snippet

Executed as user: NT AUTHORITY\NETWORK SERVICE. ...00 for 32-bit

Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 9:24:21 AM Error: 2007-08-08 09:24:22.28

Code: 0xC0202009 Source: TestPckg5 Connection manager "server2.MySourceDB.MyDBUser"

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.

Error code: 0x80040E4D. An OLE DB record is available. Source:

"Microsoft SQL Native Client" Hresult: 0x80040E4D Description:

"Login failed for user 'MyDBUser'.". End Error Error: 2007-08-08 09:24:22.28

Code: 0xC020801C Source: TestPckg5 Log provider

"{8C4BDB79-EEE9-4280-B15E-4E63B4B683DF}"

Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

The AcquireConnection method call to the connection manager "server2.MySourceDB.'MyDBUser'"

failed with error code 0xC0202009. There may be error messages posted before

this with more information on why the AcquireConnection method call failed.

C... The package execution fa... The step failed.

How can I fix the error. I'm not familiar with SSIS so much.

Thanks.

|||

The error says login failed for user "MyDBUser". Check the login credentials, if you are using package configuration check the configuration file. Since SSIS does not store the password in the configuration file, you will need to manually enter the password in the configuration file.

Thanks

|||

the user name and password for the package are correct. the package is running good from the BIDS. only when I run it in a job from the sql manamgement studio it fails. I didn't define configuration file for the job. what should be in this file. how do I do it. I'm not familiar so much with SSIS. can u give me an example of a configuration file, and explain how to configure it to this job?

Appriciate your help.

|||

I found the problem. I change the protection level for the package to 'rely on server storage and reles..'.

now it works.

error running ssis package

Hello,

I created a ssis package to transfer data between tables of sql2005 DB to another sql2005 database.

when i run it from BIDS with right click -- > execute package i get this error:

Code Snippet

Error: 0xC002F325 at CopyTables1, Transfer SQL Server Objects Task: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".

anyone can help here.

Thanks.

Check your connection managers... it appears that your login credentials were lost.

|||

Thanks for your anwer.

The connection i configured in the ssis package seems good. how do I check the connection managers exactly?

i'm not so familiar with the BIDS.

Thanks.

|||

In BIDS, below the main scren palatte there is a tab which is labeled "Connection Mangers". You can check and see which connection manager you are using for the task or transform that failed (by double clicking the task or transform), then double click on the connection manager which is giving you the problem. You should see your connection credentials (provider / server name / authentication / initial catalog / etc...)

click on the "test connection" button in the lower left hand corner.

NOTE: if you are using sql authentication, you will not see your password as SSIS does not store this in plain text.

|||

Hi,

Thanks for your answer.

I tested the connection successfully in the connection manager.

I still get this error when I run the pacakge!!

i'm using sql authentication.