Post reply

SSIS Text to AS400

  • January 7, 2011 at 3:56 am

    #245033

    I'm relatively new to SSIS. What is the best way to import a text file to AS400. I'm having a trouble on the AS400 part since I can't seem to get the correct destination connection. I recently downloaded the OLEDB provider for DB2. Is this the correct connection manager to use?

    On the DATA SOURCE box below, is that used for a connection string or the SERVER NAME?

    Thank in advance.

  • January 11, 2011 at 9:18 am

    #1271935

    I finally figured out what parameters to place in it.

    TCP/IP settings is for the IP Address of the AS400

    Initial Catalog you can get by invoking WRKRDBDIRE from the AS400 console.

    Package collection is for the librabry you are using

    On my SSIS package, I can easily get data from the AS400 [Table ABC] then save into a SQL server or text file etc by using a SQL command.

    HOWEVER, I had issues writing back to the AS400. I was importing a text file back to the AS400 table [Table ABC] but I don't get to see the table as an option to write to.

Viewing 2 posts - 1 through 2 (of 2 total)

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