February 6, 2009 at 3:28 am
Hello,
Which provider should I use for transferring data from as400? I cannot use Microsoft provider as I am using standard edition. As for IBM providers there are three ones for native ole db:
ibm db2 udb for iseries ibmda400 olde db provider
ibm db2 udb for iseries ibmdasql olde db provider
ibm db2 udb for iseries ibmdarla olde db provider
and there are the same three for Ado.Net
Apart from ole db I can use ODBC and use the DNS I have created in data sources.
Which one will be the fastest? I believe using native will be better but which one from the three possibilities?
Also, are there any gotchas to take into consideration? Any tips and tricks?
Thank you.
February 9, 2009 at 6:02 am
Anyone?
February 9, 2009 at 11:58 am
I have these two threads I covered the automation part only because I don't have access to DB2 AS400 but you can use the ODBC connection. If you choose to run it as a Job the Agent must be admin and the account used to create the package must be admin also.
Kind regards,
Gift Peddie
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply