
· SSIS³Ö¾Ã²éÕÒ¡£Ö´ÐвéÕÒÊÇ×î³£¼ûµÄ³éÈ¡¡¢×ª»»ºÍ¼Ó
Ñ§Ð£ÍøÕ¾¼°Ñ§Ð£ÐÅÏ¢¹ÜÀí·½°¸Êé
ÔØ(ETL)²Ù×÷¡£ÕâÔÚÊý¾Ý²Ö¿âÖÐÓÈΪÆÕ±é£¬µ±Êµ¼Ê¼Ç¼±ØÐëʹÓòéÕÒÀ´×ª»»ÒµÎñ¼üµ½ËüÃÇÏàÓ¦µÄÌæ´úÖÐȥʱ¡£SSIS ÔöÇ¿Á˲éÕÒµÄÐÔÄÜÒÔÖ§³Ö´óÐÍ±í¡£
ËÄ¡¢ÏîÄ¿ÈËÔ±ÅäÅZ
¸ù¾Ý±¾ÏîÄ¿µÄ¹¤×÷ÄÚÈݺͷ¶Î§£¬½«³ÉÁ¢Ò»¸ö3-6ÈË×óÓÒµÄÏîÄ¿¹¤×÷×éÀ´¸ºÔð±¾ÏîÄ¿µÄ¿ª·¢¡£ÁíÍ⣬±¾ÏîÄ¿ÉèÁ¢ÏîÄ¿×ܼ࣬ÔÚ¹«Ë¾µÄ²ãÃæÉϱ£Ö¤ÏîÄ¿µÄ×ÊÔ´·ÖÅ䡢е÷¿Í»§¹ØÏµ¡£
ϵͳ¹¹¼ÜÉè¼ÆÊ¦£ºÔÚÏîÄ¿ÖУ¬ÏµÍ³¹¹¼ÜÉè¼ÆÊ¦ÊÇÏîÄ¿×éµÄ¼¼Êõ¸ºÔðÈË£¬¸ºÔðÏîÄ¿µÄ¼¼ÊõÌåϵ¼Ü¹¹·½°¸ÓëÑ¡Ôñ£¬°üÀ¨Ö÷»ú·þÎñÆ÷¡¢²Ù×÷ϵͳ¡¢ÍøÂç¼Ü¹¹µÈϵͳ»ù´¡×é³É¼¼ÊõÔªËØÌṩ×ÉѯºÍ¹æ»®£¬Ê¹Ö®Âú×ãϵͳµÄÒªÇó¡£
´´ÒâÉè¼ÆÊ¦£º´ÓÊÂÏîÄ¿ÕûÌåÉϵĴ´Òâ¡¢¹æ»®¡¢ÊÓ¾õÉè¼ÆºÍ½»»¥±íÏÖµÄÐÎʽµÄ·½Ïò°ÑÎÕºÍÉè¼Æ·½°¸µÄÌá½»£¬¶ÔÏîÄ¿¹æ»®Éè¼ÆµÄÖÊÁ¿ÊµÊ©¿ØÖÆ¡¢Ö¸µ¼Óë¼à¶½¡£
ÏîÄ¿¾Àí£ºÏîÄ¿¾Àí¸ºÔðÏîÄ¿¹ÜÀí¡¢×éÖ¯¡¢Ðµ÷£¬¶ÔÏîÄ¿×ÊÔ´½øÐпØÖÆ£¬ÊÇÏîÄ¿Äܹ»°´Õռƻ®ÊµÊ©£¬Âú×ãÏîÄ¿¹æ¶¨µÄÒµÎñÐèÇó¡£ÏîÄ¿¾Àí¶ÔÏîÄ¿µÄÖÊÁ¿¡¢½ø¶ÈºÍ³É±¾¸ºÔð¡£
¹¦ÄÜ¿ª·¢×鳤£º¹¦ÄÜ¿ª·¢×鳤ÊÇÏîÄ¿×éÖÐÓ¦ÓÃϵͳ¹¦ÄÜ¿ª·¢²¿·ÖµÄʵʩ¸ºÔðÈË¡£Í¬Ê±²ÎÓ빦ÄÜÉè¼ÆÓë¹æ»®¡£½«¹¦Äܹ滮Éè¼Æ¼¼Êõϸ»¯£¬Öƶ¨¼¼Êõ¿ª·¢±ê×¼Óë¹æ·¶£¬²¢Êµ¼Ê²ÎÓ뿪·¢ºÍ¿ª·¢¹ÜÀí¡£±ØÒªÊ±¿ÉÒÔ¿¼ÂÇÓÉϵͳÉè¼ÆÊ¦¼æÈΡ£ ¿ª·¢ÈËÔ±£ºÊµ¼Ê²ÎÓëϵͳ¿ª·¢µÄ³ÌÐòÈËÔ±¡¢ÍøÕ¾½çÃæÉè¼ÆÈËÔ±Óë²âÊÔÈËÔ±£¬¸ºÔðÖ´ÐоßÌåµÄ¹¤×÷¡£
Ñ§Ð£ÍøÕ¾¼°Ñ§Ð£ÐÅÏ¢¹ÜÀí·½°¸Êé
Îå¡¢ÏîĿʵʩϸÔò
ÏîÄ¿½«ÒÀ¾Ýʵ¼ÊÇé¿ö·Ö5¸ö½×¶Îʵʩ£¬Ô¤¼ÆÐèÒª45¸ö¹¤×÷ÈÕ¡£
£¨1£©ÊµÊ©ÐèÇó×÷Ïêϸµ÷ÑС£
£¨2£©ÒÀ¾Ýµ÷Ñнá¹û½øÐÐÕû¸öϵͳÉè¼Æ¡£ £¨3£©¿ª·¢ÏµÍ³¡£
£¨4£©°²×°µ÷ÊÔ¼°ÊÔÔËÐС£ £¨5£©¹¤³ÌÑéÊÕ¡£
ʱ¼ä±í2012Äê1ÔÂ1ÈÕ¡ª¡ª2012Äê02ÔÂ29ÈÕ¡£
¹¤×÷½ø³Ìʱ¼ä±í
¸ù¾ÝÎÒÃǶԴËÏîÄ¿µÄÐèÇó×öµÄ·ÖÎö£¬±¾ÏîÄ¿µÄÕû¸ö¹¤×÷ÖÜÆÚ´óÖÂΪ30¸ö¹¤×÷ÈÕ£¬ Ö÷ÒªÈÎÎñµÄ¹¤×÷ʱ¼ä³õ²½·ÖÅäÈçÏ£º
Ñ§Ð£ÍøÕ¾¼°Ñ§Ð£ÐÅÏ¢¹ÜÀí·½°¸Êé
±¨ ¼Û
°Ù¶ÈËÑË÷¡°77cn¡±»ò¡°Ãâ·Ñ·¶ÎÄÍø¡±¼´¿ÉÕÒµ½±¾Õ¾Ãâ·ÑÔĶÁÈ«²¿·¶ÎÄ¡£Êղر¾Õ¾·½±ãÏ´ÎÔĶÁ£¬Ãâ·Ñ·¶ÎÄÍø£¬Ìṩ¾µäС˵ҽҩÎÀÉúÑ§Ð£ÍøÕ¾¼°Ñ§Ð£ÐÅÏ¢¹ÜÀí·½°¸Êé(3)ÔÚÏßÈ«ÎÄÔĶÁ¡£
Ïà¹ØÍÆ¼ö£º
