本文介绍了如何完成ETL任务？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ 我应该执行ETL，其中源是一个大型且设计不良的sql 2k数据库和一个设计较好的sql 2k5数据库。我认为SSIS是必经之路。谁能建议一个待办事项清单或核对清单或需要注意的事情，这样我就不会忘记什么？我应该如何处理，以免以后再咬我。 解决方案我正在为我所在的公司开发ETL。 我们正在与SSIS合作。 使用api生成和构建我们自己的dtsx软件包。 SSIS，它对管理错误并不友好。有时，您会收到一个 OleDb错误，该错误可能在上下文上有很多不同的含义。 阅读API文档（他们说的不多）。 / p> 一些可以帮助您从此处开始的链接： http://technet.microsoft.com/de-de/library/ms135932（SQL.90）.aspx http://msdn.microsoft.com/en -us / library / ms345167.aspx http://msdn.microsoft.com/en-us/library/ms403356.aspx http：//www.codeproj ect.com/KB/database/SSISProgramming.aspx?display=PrintAll&fid=382208&df=90&mpp=25&noise=3&sort=Position&view=Quick&fr=26&select=2551674 http：// www.codeproject.com/KB/database/foreachadossis.aspx http://wiki.sqlis.com/default.aspx/SQLISWiki/ComponentErrorCodes.html http：// www .new.facebook.com / inbox / readmessage.php？t = 1041904880323＃/ home.php？ref = logo http://technet.microsoft.com/en-us/library/ms187670.aspx http://msdn.microsoft.com/ja-jp/library/microsoft.sqlserver.dts.runtime .foreachloop.foreachenumerator.aspx http://www.sqlis.com/post/Handling-different-row-types-in-the-same-file.aspx http://technet.microsoft.com/zh-cn/library/ms135967（SQL.90）.aspx http://msdn.microsoft.com/zh-CN/library/ms137709（ SQL.90）.aspx http://msdn.microsoft.com/zh-CN/library/ms345164（SQL.90）.aspx http://msdn.microsoft.com/en-us/library/ms141232。 aspx http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx http://www.ivolva.com/ssis_code_generator.html http://www.ivolva.com/ssis_wizards.html http://www.codeplex.com/MSFTISProdSamples http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/Q_23972361 .html http://forums.microsoft.com/MSDN/MigratedForum.aspx?siteid=1&PostID=1404157 http://msdn.microsoft.com/en-us/ library / aa719592（VS.71）.aspx http://forums.microsoft.com/MSDN/MigratedForum.aspx?siteid=1&ForumID=80 http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx http://blogs.conchango.com/jamiethomson/archive/2007/03/13/SSIS_3A00_-Property-Paths-syntax.aspx http://search.live.com/results.aspx?q=%s&go=Buscar&form=QBJK&q1=macro%3Ajamiet.ssis http ：//toddmcdermid.blogspot.com/2008/09/using-performupgrade.html？showComment = 1224715020000 http://msdn.microsoft.com/en-us/library/ms136082.aspx http://support.microsoft.com / kb / 839279 / zh-CN 对不起，垃圾邮件他们对我很有用。 I am supposed to perform ETL where source is a large and badly designed sql 2k database and a a better designed sql 2k5 database. I think SSIS is the way to go. Can anyone suggest a to-do list or a checklist or things to watchout for so that I dont forget anything? How should I approach this so that it does not bite me in the rear later on. 解决方案 Well i'm developing an ETL for the company where i am.We are working with SSIS.Using the api to generate and build our own dtsx packages.SSIS it's not friendly for managing errors. Sometimes you get an "OleDb Error" that could have a lot of different meanings depeding on the context.Read the API Documentation (they don't say much).Some links to help you out starting there:http://technet.microsoft.com/de-de/library/ms135932(SQL.90).aspxhttp://msdn.microsoft.com/en-us/library/ms345167.aspxhttp://msdn.microsoft.com/en-us/library/ms403356.aspxhttp://www.codeproject.com/KB/database/SSISProgramming.aspx?display=PrintAll&fid=382208&df=90&mpp=25&noise=3&sort=Position&view=Quick&fr=26&select=2551674http://www.codeproject.com/KB/database/foreachadossis.aspxhttp://wiki.sqlis.com/default.aspx/SQLISWiki/ComponentErrorCodes.htmlhttp://www.new.facebook.com/inbox/readmessage.php?t=1041904880323#/home.php?ref=logohttp://technet.microsoft.com/en-us/library/ms187670.aspxhttp://msdn.microsoft.com/ja-jp/library/microsoft.sqlserver.dts.runtime.foreachloop.foreachenumerator.aspxhttp://www.sqlis.com/post/Handling-different-row-types-in-the-same-file.aspxhttp://technet.microsoft.com/en-us/library/ms135967(SQL.90).aspxhttp://msdn.microsoft.com/en-us/library/ms137709(SQL.90).aspxhttp://msdn.microsoft.com/en-us/library/ms345164(SQL.90).aspxhttp://msdn.microsoft.com/en-us/library/ms141232.aspxhttp://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspxhttp://www.ivolva.com/ssis_code_generator.htmlhttp://www.ivolva.com/ssis_wizards.htmlhttp://www.codeplex.com/MSFTISProdSampleshttp://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/Q_23972361.htmlhttp://forums.microsoft.com/MSDN/MigratedForum.aspx?siteid=1&PostID=1404157http://msdn.microsoft.com/en-us/library/aa719592(VS.71).aspxhttp://forums.microsoft.com/MSDN/MigratedForum.aspx?siteid=1&ForumID=80http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspxhttp://blogs.conchango.com/jamiethomson/archive/2007/03/13/SSIS_3A00_-Property-Paths-syntax.aspxhttp://search.live.com/results.aspx?q=%s&go=Buscar&form=QBJK&q1=macro%3Ajamiet.ssishttp://toddmcdermid.blogspot.com/2008/09/using-performupgrade.html?showComment=1224715020000http://msdn.microsoft.com/en-us/library/ms136082.aspxhttp://support.microsoft.com/kb/839279/en-usSorry for the "spam", but they are very useful to me. 这篇关于如何完成ETL任务？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！
