I worked for a while with SQL Server and importing data from an AS400 into SQL Server and I used DB2.

As well I dont have IBM Client Access installed on my system.

Ibmda400 Ole Db Provider Download Package To

Run the self-extracting download package to create an installation folder.

We have done this so our AS400 issues a remote command to run a batch file on the SQL server to start our ETL process.

The Development Environment will use the 32 bit driver (which you will be able to see ).

Within BI studio created Source connection using.net providersodbc.

It works fine when I run from BI studio.

However when I deploy to SQlserver SSIS, I am getting error saying passowrd lenght is 0 etc.

Ibmda400 Ole Db Provider Password Within Connection

There is no option to save password within connection manager.

How can I save password within the package I need to schedule this package.

Default (I think) package is saved with sensitive information encrypted with user key.

I would need to have access (i.e.

SQL Agent as you).