July 25, 2008 at 8:48 am
Hi Folks!
I'm sure you've answered a ton of these type questions but I'm not seeing mention of what I thought was an integral part of data transfer between the AS400 and SQL - Microsoft Host Integration Services. Since I'm just getting my feet wet with SQL2K5, I'm wondering if it's possible to perform large data transfers using SSIS WITHOUT having to install HIS. Anyone out there have some current experience or tales of woe regarding data transfer and SSIS?
Thanks ALL!
Bob
July 25, 2008 at 8:53 am
Sure you can transfer data between AS400 and SQL Server using SSIS without HIS. You can use the ODBC or OLEDB provider provided by IBM or another provider to connect to the AS400 within SSIS. There is also a .NET provider for DB2 as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 25, 2008 at 9:01 am
Good Morning Jack and Thanks for the shout back!
I REALLY appreciate the guidance on this 'fuzzy' spot......I'll give it a go then. I'm just not a big fan of peeing into the wind if you get my drift.....
Thanks Again,
Bob
July 25, 2008 at 9:05 am
I know what you mean. I did use the ODBC driver back in DTS days and have used the .NET driver in an ASP.NET web service. They work alright. Just remember the drivers will have to be installed in the SQL Server you run the package from. I would forget that.:D
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 25, 2008 at 9:28 am
Thanks Again Jack -
At this point I'm not really sure which direction to head with this since I have yet to use SSIS and this whole thread is an attempt to prevent having to upgrade from SQL2K5 Standard to Enterprise. I have been populating a small DB under SQL2K from our AS400 using a linked server and DTS. Works well, and has never given me a lick of trouble.
Now that I'm in the middle of this SQL2K5 upgrade I'm finding out my company hasn't upgraded HIS from the 2000 version. And they're sqwauking about spending money. The driver(DB2OLEDB.exe courtesy of MS) apparently doesn't play nicely with the Standard edition so I'm trying to find a better solution for less $$$(that reads NO $$$) that doesn't use something foolish like FTP to transport the data.
Any other thoughts you might have would be MOST appreciated!
Take Care,
Bob
July 25, 2008 at 10:02 am
As much as I hate it you can use the Client Access (iSeriesAccess) ODBC or OLEDB provider within SSIS for your connection. At my current position I no longer have an AS400 to worry about so I can't give you any more help.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 25, 2008 at 10:07 am
Well I certainly do appreciate all your help Jack!
I'll give it a whirl and test a couple of different scenarios and see what works out best for us.
Thanks Again!
Bob
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply