I set up an automation script with a set variables activity and an import activity. The import wizard reads a sql query with a bind variable. I am using a sql server connection as the target database and IBM DB2 iSeries connection for the source data. When I run the import I get an error message that says Error importing data, object reference not set to an instance of an object. Additionally, if I try to set up more than 1 query within the import wizard, I get this error when tryin to save the import template. If I only set up 1 query, I am able to go through the wizard, but then I get the error when I go to run the script. I didn’t see any reference to iSeries connections and not being able to use a bind variable in an import wizard. The wizard seems to work fine with a variable and sql server to sql server connections.
Can anyone recreate this with an iSeries connection?