SQL Server BI Step by Step SSIS 7 (End)
ºÍÆäËü³ÌÐòÒ»Ñù£¬SSIS°üͬÑùÐèÒª½¡×³£¬Îȶ¨µÄÔËÐУ¬ÕâÑùµÄ³ÌÐò²ÅÓпɿ¿ÐԺͿÉÉìËõÐÔ¡£SSISÌṩÁËÈçÏ·½ÃæµÄÖ§³Ö:
1.ÊÂÎñ: ¿ÉÒÔ¶ÔÒ»¸ö³ÌÐò°üÉèÖóÉÒ»¸ö»òÕ߶à¸öÊÂÎñ£¬ÉõÖÁ¿ÉÒÔ¶ÔÁ½¸ö³ÌÐò°üÉèÖóÉÒ»¸öÊÂÎñ¡£ÎªÁ˱£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔ£¬Ä㻹¿ÉÒÔDTCÊÂÎñ»òÕßSQL ServerÒýÇ漶µÄÊÂÎñ¡£
2.¼ì²éµã: ÓÃÀ´¼Ç¼һ¸ö³ÌÐò°ü³ö´íʱÈÎÎñµÄÔËÐÐÇé¿ö£¬ÒÔ±ã³ÌÐò°üÔÙ´ÎÆô¶¯Ê±£¬Ö±½Ó´Ó·¢Éú´íÎóµÄÈÎÎñÖ±½ÓÖ´ÐÐ.
3.´íÎóÊä³ö:¼´Ê¹ÔÙÍêÃÀµÄ³ÌÐòÒ²»áÓдíÎó£¬ÓÈÆä¶ÔÓÚÊý¾ÝÁ÷ÖеÄÈÎÎñÀ´Ëµ£¬¼°ÓпÉÄÜÓÉÓÚ¸ñʽ£¬ÀàÐ͵ÈÎÊÌ⣬µ¼ÖÂÕâÒ»Ðеķ¢Éú´íÎó¡£SSISÔÊÐíÕë¶ÔÕâÑùµÄÿÐнøÐдíÎóÊä³ö´¦Àí£¬Äã¿É ÒÔ½øÐÐÐÞ¸´»òÕ߼Ǽ£¬µ±È»ÄãÒ²¿ÉÒÔºöÂÔ¡£
4.ÓÅÏÈÔ¼Êø:ÔÚ¿ØÖÆÁ÷ÖУ¬Äã²»½ö¿ÉÒÔʹÓÃÒ»¸öÈÎÎñµÄ³É¹¦£¬Ê§°Ü»òÖ´ÐнáÊø×÷ΪÌõ¼þÀ´Ö´ÐÐÏÂÃæµÄÈÎÎñ£¬ÉõÖÁ¿ÉÒÔʹÓñí´ïʽÀ´×öΪÌõ¼þ¡£
5.ʼþ´¦Àí: ÔÚSSIS°üÖУ¬Ê¼þ´¦ÀíÊǺͿØÖÆÁ÷£¬Êý¾ÝÁ÷ÏಢÁеġ£ÔÚÕâÀÄã¿ÉÒÔ¶Ô³ÌÐò°ü£¬ÈÎÎñ»òÕßÈÝÆ÷µÄ²»Í¬µÄʼþ½øÐд¦Àí£¬Ê¼þ»¹¿ÉÒÔÓÃÓÚÉèÖöϵ㲢¿ØÖÆÈÕÖ¾¼Ç¼¡£ÎÒÃÇ¿ÉÒÔʹÓÃOnErrorʼþÀ´²¶»ñ´íÎó.
6.ÈÕÖ¾¼Ç¼: ¿ÉÒÔÔÚÔËÐÐʱ£¬¼Ç¼ָ¶¨µÄʼþÐÅÏ¢£¬¿ÉÒÔ±£´æÔÚ±¾µØÎı¾»òÕßXMLÎļþÖУ¬Ò²¿ÉÒÔ±£´æµ½Êý¾Ý¿âÖУ¬»òÕßÊÇWindows EventLog£¬ProfilerÎļþÖУ¬ÉõÖÁÄã¿ÉÒÔÀ©Õ¹×Ô¼ºµÄÈÕÖ¾¼Ç¼¡£
ÐèÇó:
ΪÁ˺ÍÆäËüϵͳ¼¯³É£¬AdventureWorksϵͳµÄ²úÆ·¼Û¸ñʵʱ¸üУ¬ÐèÒª´ÓÒ»¸öÖ¸¶¨µÄURLÏÂÔØÒ»¸öѹËõÎļþ£¬½âѹºó£¬¶ÔÕâ¸öÊý¾ÝÎļþ½øÐзÖÎöµ¼Èë¡£ÓÉÓÚÏÂÔصÄÎļþÊÇÓÉÒ»¸ö·Ç³ÌÐòά»¤µÄÎļþ£¬ÓÉÓÚÈËΪÒòËØ£¬ÀïÃæµÄÊý¾Ý¸ñʽÓпÉÄÜÓдíÎ󣬵«ÊÇÒªÇóºöÂÔÕâÑùµÄÊý¾Ý¡£ÁíÍ⣬Èç¹û´¦Àíʧ°Ü£¬ÐèÒª¶Ô±£ÁôÀúÊ·Îļþ¡£Èç¹û·¢Éú´íÎó£¬ÐèÒª·¢ËÍ´íÎóEmail.ͬʱÐèÒª±£Áô³ÌÐòÈÕÖ¾£¬ÒÔ±ã²éÕÒ´íÎóÔÒò¡£
ʵÏÖ:
1. ÔÚÄãµÄDÅÌÏÂÃæн¨Ò»¸öProductPriceÎļþ¼ÐÀ´´æ·ÅѹËõºÍÊý¾ÝÎļþ£¬ÔÚÏÂÃæн¨Ò»¸öbakĿ¼´æ´¢±¸·ÝÎļþ¡£
2. ´´½¨Ò»¸öSSIS°ü£¬Í¬Ê±Ð½¨ÒÔϱäÁ¿:
±ä¸üÃû
ÀàÐÍ
Öµ
˵Ã÷
filePath
String
D:\ProductPrice\
Êý¾Ý¸ùĿ¼
dataPat
Ïà¹ØÎĵµ£º
´Ó²»Í¬µÄ½Ç¶È£¬ÎÒÃÇ¿ÉÒÔ°ÑSQL ServerÊý¾Ýƽ̨»®·ÖΪ¶à¸ö×é¼þ¡£ÎÒÃÇÏÂÃæ°´ÕÕSQL Server Internal Teamͨ³£µÄ»®·ÖÔÔò£¬°ÑSQL ServerÊý¾Ýƽ̨»®·ÖΪÈçÏ£º
SSAS: SQL Server Analysis Service¡£Ö÷ÒªÓÃÀ´×ö·ÖÎöÓ㬱ÈÈçCube£¬¿ÉÒÔ´Ó²»Í¬µÄ½Ç¶ÈÉóÊÓÊý¾Ý¡£
SSIS: SQL Server Integration Servi ......
UPDATe [Sale_Goods] SET [Catalog33_ID] = [Catalog].[ID]
from [Sale_Goods]
LEFT OUTER JOIN [chdy222] ON [Sale_Goods].[Code] = [chdy222].[ID]
LEFT OUTER JOIN [Catalog] ON [chdy222].[ufidaname] = [Catalog].[Name] and [Catalog].[Type]=33
WHERE [Catalog].[ID] IS NOT NULL ......
ÈçºÎ²é¿´SQL Server ²¹¶¡µÄ°æ±¾ [http://blog.sina.com.cn/s/blog_4a5bf0b7010008bz.html]
ÈçºÎ²é¿´SQL Server ²¹¶¡µÄ°æ±¾£¿Õâ¸öÌâÄ¿ÌýÆðÀ´Ê®·ÖÞÖ¿Ú£¬Ó¢ÎÄÓ¦¸ÃÕâÑùд“How to find the service pack version installed on SQL Server using”£¬Õâ¸öÎÊÌâÎÒÒ»Ö±ÔÚÕÒ£¬SQL ServerһֱûÓÐÏñÆ ......
¼à¿ØÊý¾Ý¿âÐÔÄܵÄSQL»ã×Ü ¡¾http://hi.baidu.com/g%5Fliying/blog/item/89711cfc27b82ff4fc037f80.html¡¿
1. ¼à¿ØÊÂÀýµÄµÈ´ý
select event,sum(decode(wait_Time,0,0,1)) "Prev",
sum(decode(wait_Time,0,1,0)) "Curr",count(*) "Tot"
from v$session_Wait
group by event order by 4;
2. »Ø¹ö¶ÎµÄÕùÓÃÇé¿ö
se ......
ÒªÇ󣺲éѯÿ¸öÀÏʦËù´ø±ÏÒµÉè¼ÆµÄ»ã×ÜÇé¿ö£¬±ÏÒµÉè¼ÆѧÉú·Ö±¾¿Æ¡¢×¨¿Æ£¬ÔºÍâ¡¢ÔºÄÚ£¬ÒªÇóµÃµ½µÄ½á¹ûÐÎʽÈçÏ£º
½ÌʦÃû ÔºÄÚ±¾¿Æ Ô°ÄÚר¿Æ ÔºÍâ±¾¿Æ ÔºÍâר¿Æ ºÏ¼Æ
Ïà¹ØµÄ±íÓУºÑ§Éú±í£¨°üº¬Ñ§Éú²ã´Î£©¡¢½Ìʦ±í£¨½ÌʦÃû£©¡¢Ñ§Éú¿ÎÌâ±í£¨Ñ§Éú½Ìʦ¶ÔÓ¦¹ØϵÒÔ¼°ÔºÄÚÔºÍâÐÅÏ¢£©¡£
SQLÓï¾äÈçÏ£º
select
  ......