Long back I had a trouble in using Excel connection manager in SSIS 2008, for that situation i was just changed project properties
Run64BitRuntime = false
then I was able to use Excel connection manager.
again not exact but last week i was stuck with another issue which is more related to this.
When we are using Fuzzylookup with Run64BitRuntime changing it stuck with undefined bug. It’s not a failure or not a success. It’s just stuck.
Now for the fuzzyLookUp issue, when I tried with some OLEDB source, and when I made Run64BitRuntime = True,
So now the problem is
- Run64BitRuntime = False
Then Excel connection manager fine , but FuzzyLookUp is not working.
- Run64BitRuntime = True
Then Excel connection manager is not working, but FuzzyLookUp will work.
Hope you will like this post on Microsoft SQL Server.
If you really like reading my blog and understood at least few thing then
please don’t forget to subscribe my blog.
Connect With me on