Microsoft@frugecn, after several tries, our DBA and I were able to make this connector work. We were initially getting errors on the server, even after the connectors were installed on it.
What we learned:
- I had to install both 4.0 and 5.0 64-bit on my laptop, even though our server only has 5.0
- Can't use existing projects (prior to server connector install) with packages using the connector. I had to create a brand new project, then create the new package, then deploy.
- But, tried redeploying the same package (even without doing any changes on it), it will fail. Have to redeploy the project, not just the package. I'd like to find out if there's a way to redeploy just a single package with the connector still working.
Hope this helps anyone who might have to do a lot of trial and error when trying to make these connectors work. It's really superfast. Our SSIS jobs that takes hours now finishes in minutes.
Thanks everyone.
