June 22, 2009 at 3:41 pm
I want to transfer files from an iSeries running v5r3 OS. I know how to create an SSIS Data Flow task.
What is the best provider (IBMDA400, IBMDASQL, IBMDARSL, DB2OLEDB) or is there a better provider? I am using SQL 2005 Developer.
I want to run this at nught, unattended and don't want the iSeries Prompt to sign on to the iSeries.
Thanks for any help.
Jim
June 23, 2009 at 8:00 am
If you need a 'Real Good' provider, there is one - Ritmo provider (ADO.NET) performs 3 times faster than a oledb provider. I tested it in our environment and works really good. Integrates seamlessly with SSIS.
p.s - It is not free.
June 23, 2009 at 9:50 am
Jim,
I have created a package using the ibmdasql provider. The performance is great. I use it to download data into SQL for our GIS system. The trouble I am having is I can run the package from BIDS and in IIS but when I make it a job in SQL it errors out. I am pretty sure that the error I am getting is not from the provider.
HTH
Quinn
June 23, 2009 at 11:24 am
I use HitOLEDB400 from Hit Software and it performs quite well.
With "quite well" I mean we can transfer 2 Gb of data from iSeries to SQLServer in less than 2 minutes.
It's a quite expensive provider, anyway.
Regards
Gianluca
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply