Solved

can't lookup on SQL Analysis Service

Posted on 2014-11-13
4
69 Views
Last Modified: 2016-02-11
A Lookup process on SQL SSIS doesn't work and it can't route a lookup value to another process. It works fine for other. Any idea how this process doesn't work ? Any suggestion to test ?

Tks
Lookup-1.png
Lookup-2.png
Lookup-3.png
0
Comment
Question by:AXISHK
  • 2
4 Comments
 
LVL 14

Expert Comment

by:Vikas Garg
ID: 40441850
Hi,

What you are trying to do with lookup since you are first splitting them and them joining in Union All.

However Lookup will not work only if the data type is different .

and one more thing you have to set the no match rows to redirect to no match output

Look up
0
 

Author Comment

by:AXISHK
ID: 40441929
It is implemented by the vendor and intended to union both matched and unmatched result...

Other lookup transform work like this but it can direct a lookup column.

I have also check the data type and they are the same. Any other suggestion ?

Tks
0
 
LVL 9

Accepted Solution

by:
Valliappan AN earned 500 total points
ID: 40445757
Did you check all source and destination tables, the properties, do have the REGION_COUNTRY_IDX in their outputs defined, as you do while merge.

If so, try simplifying your operations, by just doing a single UNION ALL, or without it. Another option, would be refresh links, or recreate them. Its all a guess though.

HTH.
0
 

Author Closing Comment

by:AXISHK
ID: 40446467
Tks. Remove the Union All task and recreate it again. It fixes the problem, Tks
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now