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 |
|
pecunn
Starting Member
20 Posts |
 Posted - 2011-05-25 : 04:15:40
|
| Hi guys,I have couple data flows with some of them using look up and import direct from excel, everything is working fine. On my final step i put sequenece container to make it transactional however it cause hang on my data flow that using look up. It just yellow and stay there.I have try to disable this data flow and everything is work fine. I also have tried to change to partial cache and no cache but no luck.Do you guys have any idea what cause it? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-05-25 : 04:20:59
|
| Well, it depends on the lookup. The lookup is basically a sql query with a join condition and depending on the size of the lookup table and the index situation it might take a long time. You need to provide some more details about this lookup table and the amount of rows you're joining.- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
pecunn
Starting Member
20 Posts |
Posted - 2011-05-27 : 02:50:36
|
| thanks, i fixed my problem. It was because i run in big block transaction and the ref look up table was not committed.My solution is to have multiple sub transaction inside big block transaction. Commit all look table before do look up otherwise it just hang and dont give you any error message |
|
|
|
|
|
|
Look up cause hang in data flow