Sat, 10 Oct 2009 00:35:00 GMT幸福,這麼遠,那麼甜...!http://blog.csdn.net/blogrss.aspx?username=liangCKhttp://blog.csdn.net/liangCK/archive/2009/10/10/4648375.aspxSIS “查找组件” 查找范围内的数据.<img src="http://www1.feedsky.com/t1/280725125/liangCK/csdn.net/s.gif?r=http://blog.csdn.net/liangCK/archive/2009/10/10/4648375.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liangCK/280725125/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liangCK/280725125/art01.gif" onerror="this.style.display='none'" /></a></p>Sat, 10 Oct 2009 08:35:00 +0800梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/10/4648375.aspx梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/10/4648375.aspxhttp://blog.csdn.net/liangCK/rss.aspxcsdn.net/liangCK/~5967357/280725125/4074597http://blog.csdn.net/liangCK/archive/2009/10/10/4648353.aspx在SSIS的中没有提供有ISNUMERIC这个函数.所以如果想在要”条件拆分”中.将某个列数据是数值的数据和不是数值的数据分支的话,就不能直接使用”条件拆分”组件.在这里使用”脚本组件”来完成此任务.<img src="http://www1.feedsky.com/t1/280718590/liangCK/csdn.net/s.gif?r=http://blog.csdn.net/liangCK/archive/2009/10/10/4648353.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liangCK/280718590/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liangCK/280718590/art01.gif" onerror="this.style.display='none'" /></a></p>Sat, 10 Oct 2009 08:22:00 +0800梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/10/4648353.aspx梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/10/4648353.aspxhttp://blog.csdn.net/liangCK/rss.aspxcsdn.net/liangCK/~5967357/280718590/4074597http://blog.csdn.net/liangCK/archive/2009/10/10/4648339.aspxSSIS中数据源和数据目标中的”保留空值”<img src="http://www1.feedsky.com/t1/280716545/liangCK/csdn.net/s.gif?r=http://blog.csdn.net/liangCK/archive/2009/10/10/4648339.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liangCK/280716545/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liangCK/280716545/art01.gif" onerror="this.style.display='none'" /></a></p>Sat, 10 Oct 2009 08:09:00 +0800梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/10/4648339.aspx梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/10/4648339.aspxhttp://blog.csdn.net/liangCK/rss.aspxcsdn.net/liangCK/~5967357/280716545/4074597http://blog.csdn.net/liangCK/archive/2009/10/10/4648334.aspx在”脚本任务”中访问变量.我们可以使用Dts.Variables(“变量名”).Value 的方法得到变量的值. 但如果变量是ADO的结果集.就需要将ADO结果集填充到一个DataTable中.然后再查这个DataTable.<img src="http://www1.feedsky.com/t1/280716107/liangCK/csdn.net/s.gif?r=http://blog.csdn.net/liangCK/archive/2009/10/10/4648334.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liangCK/280716107/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liangCK/280716107/art01.gif" onerror="this.style.display='none'" /></a></p>Sat, 10 Oct 2009 08:06:00 +0800梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/10/4648334.aspx梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/10/4648334.aspxhttp://blog.csdn.net/liangCK/rss.aspxcsdn.net/liangCK/~5967357/280716107/4074597http://blog.csdn.net/liangCK/archive/2009/10/10/4648328.aspx介绍几个简单的SSIS表达式.<img src="http://www1.feedsky.com/t1/280716088/liangCK/csdn.net/s.gif?r=http://blog.csdn.net/liangCK/archive/2009/10/10/4648328.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liangCK/280716088/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liangCK/280716088/art01.gif" onerror="this.style.display='none'" /></a></p>Sat, 10 Oct 2009 08:03:00 +0800梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/10/4648328.aspx梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/10/4648328.aspxhttp://blog.csdn.net/liangCK/rss.aspxcsdn.net/liangCK/~5967357/280716088/4074597http://blog.csdn.net/liangCK/archive/2009/10/03/4628802.aspx之前发过的,不过因为格式的问题删掉了,现在重新发上来.<img src="http://www1.feedsky.com/t1/280716089/liangCK/csdn.net/s.gif?r=http://blog.csdn.net/liangCK/archive/2009/10/03/4628802.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liangCK/280716089/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liangCK/280716089/art01.gif" onerror="this.style.display='none'" /></a></p>Sat, 03 Oct 2009 10:22:00 +0800梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/03/4628802.aspx梁嘉辉http://blog.csdn.net/liangCK/archive/2009/10/03/4628802.aspxhttp://blog.csdn.net/liangCK/rss.aspxcsdn.net/liangCK/~5967357/280716089/4074597http://blog.csdn.net/liangCK/archive/2009/09/15/4555540.aspx在使用SQL SERVER将EXCEL导入到数据库中的时候.经常会发生一些问题.会让我们有些感觉到莫名其妙.今天在论坛上.一个朋友在使用SSIS将EXCEL导入到SQL SERVER的数据库内的时候.发生了这个错误根据这个提示.我们一步一步来解决.<img src="http://www1.feedsky.com/t1/280716090/liangCK/csdn.net/s.gif?r=http://blog.csdn.net/liangCK/archive/2009/09/15/4555540.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liangCK/280716090/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liangCK/280716090/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 15 Sep 2009 17:10:00 +0800梁嘉辉http://blog.csdn.net/liangCK/archive/2009/09/15/4555540.aspx梁嘉辉http://blog.csdn.net/liangCK/archive/2009/09/15/4555540.aspxhttp://blog.csdn.net/liangCK/rss.aspxcsdn.net/liangCK/~5967357/280716090/4074597http://blog.csdn.net/liangCK/archive/2009/09/11/4543043.aspx分析非聚集索引中覆盖的问题,比较在排序中的差异.<img src="http://www1.feedsky.com/t1/280716091/liangCK/csdn.net/s.gif?r=http://blog.csdn.net/liangCK/archive/2009/09/11/4543043.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liangCK/280716091/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liangCK/280716091/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 11 Sep 2009 15:22:00 +0800梁嘉辉http://blog.csdn.net/liangCK/archive/2009/09/11/4543043.aspx梁嘉辉http://blog.csdn.net/liangCK/archive/2009/09/11/4543043.aspxhttp://blog.csdn.net/liangCK/rss.aspxcsdn.net/liangCK/~5967357/280716091/4074597http://blog.csdn.net/liangCK/archive/2009/09/11/4542991.aspx使用SQL SERVER 2005及以上版本的CLR集成,编写计算每个组内的中位数.<img src="http://www1.feedsky.com/t1/280716092/liangCK/csdn.net/s.gif?r=http://blog.csdn.net/liangCK/archive/2009/09/11/4542991.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liangCK/280716092/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liangCK/280716092/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 11 Sep 2009 15:14:00 +0800梁嘉辉http://blog.csdn.net/liangCK/archive/2009/09/11/4542991.aspx梁嘉辉http://blog.csdn.net/liangCK/archive/2009/09/11/4542991.aspxhttp://blog.csdn.net/liangCK/rss.aspxcsdn.net/liangCK/~5967357/280716092/4074597http://blog.csdn.net/liangCK/archive/2009/07/13/4343782.aspx使用SQL SERVER 2005及以上版本的CLR集成.编写一个可以对文件夹进行压缩/解压的CLR存储过程.<img src="http://www1.feedsky.com/t1/280716093/liangCK/csdn.net/s.gif?r=http://blog.csdn.net/liangCK/archive/2009/07/13/4343782.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/liangCK/280716093/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/liangCK/280716093/art01.gif" onerror="this.style.display='none'" /></a></p>Mon, 13 Jul 2009 11:23:00 +0800梁嘉辉http://blog.csdn.net/liangCK/archive/2009/07/13/4343782.aspx梁嘉辉http://blog.csdn.net/liangCK/archive/2009/07/13/4343782.aspxhttp://blog.csdn.net/liangCK/rss.aspxcsdn.net/liangCK/~5967357/280716093/4074597