Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kunaaldesai
Starting Member
36 Posts |
 Posted - 2009-06-28 : 18:14:35
|
| This made my life miserable. I am trying to import some data from a text file and load it to an SQL table. in between the transfer, I am making a transformation with look up component.its like Flat file source--> Lookup( which should join and give me the result)--> oledb destination.Now, when I try to load data without using Look up then I am able to do it but when Look up comes in the scenario then bot transfer and transformation falis and I have been loking for the solution for two days and nothing worked out. Please somebody helpKunal |
|
|
Haarish
Starting Member
30 Posts |
Posted - 2009-07-03 : 06:13:24
|
| Kunaal, I did something similar to this yesterday and it worked! What are trying to do? What I did exactly was, in the 'Columns' tab of the lookup task, I right clicked on the available columns and created a mapping i.e the source and destination column to map. I also chose the column that I needed as output from the task ( I needed a different column as the output than which was used in the comparison). I had re-directed the unmatched rows to the error output and if there were any unmatched rows, I failed the package! Does that help you? |
 |
|
|
kunaaldesai
Starting Member
36 Posts |
Posted - 2009-07-07 : 20:49:10
|
| Hi haarish, I am sorry for the late reply. Well, What I was doing wrong was in Look up settings. In General tab--> Specify how to handle rows with no matching entries, I had mistakenly selected option --> Redirect rows to error output instead of " redirect rows to no match out put.That was the problem and now it seems to be working fine. Thank you very much for your concern Haarish.Anything |
|
|
|
|
|
|
SSIS Look out transformation prolem