SSIS: Lookup Error: Row yielded no match during lookup
Categories: Database; Tagged with: Database • SQL • SSIS; @ October 24th, 2012 14:14Input: row set;
Output: validate the records using the other table’s data, and output the result.
Error Mesg: Error: 0xC020901E at Data Flow Task, Lookup 1 [2409]: Row yielded no match during lookup.
In SSIS 2005, if can not find the corresponding record, the component will be failed by default.
So the Error occurred.
What we need to do is, changing the ‘Error Output’ of the lookup component, from ‘Fail Component’ to ‘Redirect row’;
Output:
故乡
Categories: 分享; Tagged with: 邵薇故乡; @ October 18th, 2012 21:56下午四点钟, 十五楼会议室, 电话会议. 我拖着下巴, 呆滞的看着窗外, 脑子里什么都没有, 耳朵也关掉了.
应该是刚下过雨, 不阴不晴的就像深秋的傍晚. 会议室里的冷气开得很大, 不自觉的系上了袖口的扣子. 呱啦呱啦的英语在电话里噼里啪啦的响着, 我不想听, 瞪着窗外河里的游船发呆, 我想给自己制造另外一个季节.
外面的高楼不多, 河里的游船稀稀拉拉的过来又过去, 冷气呼呼的吹在身上, 像极了深秋放学前的阴冷教室. 我盼望时间过得快一些, 快些放学. 跑过秋风, 跑过落叶, 坐在炕头上等着白菜炖粉条. 可我知道我只是在做梦, 很快老板就会有一堆问题问我, 我也知道这里一直都是夏天, 一走出大门就是滚滚热浪.
明天再熬一天, 后天就是周末了, 想到这里我又打起了精神.
上周末, 我看完了邵薇的<<故乡>>, 我想说, 这是一本不错的书.
我以前没有听说过邵薇, 甚至连万县我也只是知道在四川有这么个地方而已.
关于童年, 写的很细腻传神, 一个小女孩, 蹦蹦跳跳的走过来, 兜里可能揣着一块糖, 也可能是五分钱, 高兴的走在人生的路上, 坚强的, 倔强的成长, 含着泪水, 远在他乡.
(有一天我下班后在地铁上看这本书, 看的太忘我, 地铁坐过三站后才发现)
为什么要离家, 为什么要离家这么远?
“一个人和一个城市 到底有什么关系 为什么李白/杜甫的诗歌 充满乡愁”
可你所谓的远方, 可能就是我的故乡.
昨天我们换了办公室, 之前的小办公室里有三个人: 一个缅甸人, 一个印度人, 还有一个是我. 我们都是持工作签证的外国人, 在这飘着, 心态都是在这攒几年钱回各自老家, 回到别人心里的远方.
从一个小山坡, 到一个小县城, 再从小县城到大陆最深处的鸟市, 再从鸟市到上海, 又辗转来到新加坡, 我在找什么? 下一站, 又会是哪里? 我彻底凌乱了, 元芳, 你怎么看?
BIDS: Sorting files in SSIS/DTSX projects
Categories: Database; Tagged with: BIDS • ETL • SQL Server • SSIS; @ October 17th, 2012 16:42It’s really ridiculous that we cannot sort the files in SSIS project in BIDS.
fortunately, we got a plug-in named ‘BIDS Helper’, which has a feature called ‘Sort Project Files’:
http://bidshelper.codeplex.com/
Sort Project Files
This feature adds a “Sort by name” menu option to the “SSIS Packages” folder of an SSIS project in Visual Studio:
This feature is implemented natively in BIDS in SQL2008.
Other sorting:
1. Sorting MSDB package folders
2. Sorting SQL Project Files in SQL Server Management Studio
Links:
SQL Server: Grant user access permission to database
Categories: Database; Tagged with: SQL • SQL Server; @ October 17th, 2012 12:20Grant user permission to login to the database:
USE YOUR_DB
CREATE USER ROA_NAME FOR LOGIN ROA_NAME
Add user to the group:
USER YOUR_DB
EXEC SP_ADDROLEMEMBER 'DB_DATAREADER', 'ROA_NAME'
“Members of the db_datareader fixed database role can run a SELECT statement against any table or view in the database.”
FlashBuilder4.7 Beta2发布: New cross platform development features and enhancements
Categories: Flex; Tagged with: Apache Flex SDK • Flash Builder • Flex; @ October 12th, 2012 10:29October 8, 2012 — Beta 2 of Flash Builder 4.7 is now available. This release introduces integrated support for profiling Flash content via the upcoming Project Monocle.
Download the Flash Builder 4.7 Game Development beta 2
Key features for Flash Builder 4.7 include:
- Support for Apache Flex SDK.
- New compiler support for ActionScript Projects
- Support for creating ActionScript Workers
- Support for iOS USB deployment, testing & debugging
- Support for iOS simulator