Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Another thing also - if you are using standard edition of SQL, Host Integration Server provides the same providers usually newer and I'm sure it's cheaper than others :.
In what context, and query? Our provider has been around for quite a number of years SNA 4. So, what errors are you getting? Granted, the different provider options can be a bit elusive for some, but I work personally with many VERY heavy users of DB2 around the world. We have released a different version of the provider with each major release of SQL Server.
I would highly suggest testing against it. I recently did a test against V6R1, with our newer HIS release version of the provider, and pulled 8. SSIS itself has made some improvements in how it 'caches' data sometime after SP1, which has greatly improved our download speed. Also, you can open a case with Support Services in your region Europe, America, etc against Host Integration Server and request that a case be escalated to allow you to use the 'free' provider on Standard.
We will need justification of several sorts. If you have an account manager, it is best to work with him on this. If you have any further questions regarding this, please post to the Host Integration Server forum.
This helps us in prefetching data from DB2. Reminds me, I need to blog more. If you have any issues, don't hesitate to open a support case open it against either SSIS or Host Integration Server and ask for it to be escalated to me , and I will be glad to assist you directly. This is outstanding information. I will certainly take time in the next day to gather this information regarding the DB2 environment.
I think the problem is you haven't selected a connection manager. Plus, it's not available on that screen, and has been corrected in the next version of SQL Denali. You'll need to manually select it on the properties of the destination see picture. My actual connection string is:. If you did not care about 'error redirection', you can set the FastLoad Optimize to False or leave it out. Actually I did, but I blanked it out used Snagit editor to protect the connection manager name has the company and DB2 ip.
I can't seem to get the hotfix you referenced working. After any single hotfix is applied, i receive the same error. I must be doing something goofy. Would this matter? Also, do I need the full database engine installed on my machine for this hotfix to install correctly? Do you have another box you can try, or run 'repair' on your install?
If not, I would say it's time to open a case. Do you know if there has been any traction on this issue? Prior to the application of the hotfix, the provider will work through BIDS with the exceptions to the FastLoad feature in the OLEDB Destination Component, as noted above , however, after installation of the hotfix, I see the same error included here for search engine goodness :.
If I remove the hotfix, the provider will work in the same manner prior to the hotfix being applied. And then create a link-server to verify your connection string. Do not enable transaction. My connection string works when I read from the AS, but not when I try to insert. My Connection String is below:.
Insert Into SQ4. Cannot open the table ""SQ2". Unknown provider error. Please start to create a linked server first. Use the connection string i posted above to create a linked server. Then run the "Select" query and "insert Give it a try. I have not done a thing with the distributed transaction options, the service is disabled in my services tab.
As for journaling the table, should I have to do it since I could do the same query from my other OLE provider? Well, i guess that I have written as specific as possible in the above. The next would be a private hands-on demo for you if needed.
You can find HIS from Microsoft's website. There is obviously something different with my system. Knowing that it works on yours and not on mine at least tells me that the connection string is correct. Privacy policy. NET Framework 4. There are two options for installing the Data Provider, including interactive installation and unattended installation.
The following steps guide you through interactive installation. On the License Agreement page, review the license terms, click the I accept the terms in the license agreement option, and then click Install.
0コメント