有关 ETL 的良好 SQL Server Integration Services (SSIS) 示例/样本的建议吗?
我正在寻找一些不错的示例/样本,使用 SSIS 从一个 SQL Server 数据库到另一个数据库(不一定在同一实例中)执行一些 ETL。
其想法是将数据行及其层次结构(关系)从一个 OLTP 数据库迁移到另一个数据库。
SSIS 为我们提供了一些优势,使其成为迁移/ETL 平台的不错选择(除其他外,它需要完全可配置并能够按自动计划执行)。
除了 MS 社区样本(在 Codeplex 上)之外,有谁知道任何像样的样本/示例吗?
编辑:我也看过 http://www.sqlis.com/ 虽然我还没有没有找到我正在寻找的东西..
I'm looking for some decent examples/samples using SSIS to do some ETL from one SQL Server database to another not necessarily within the same instance.
The idea is to migrate rows of data with their heirarchies (relationships) from one OLTP database to another.
There are some advantages SSIS offers us which makes it a good choice as the migration/ETL platform (amongst other things it needs to be fully configurable and able to be executed on an automated schedule).
Does anyone know of any decent samples/examples besides the MS community samples (on Codeplex)?
Edit: I've also had a look at http://www.sqlis.com/ though I haven't found exactly what I'm looking for..
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
这里有关于如何使用每个任务组件和概念的 Microsoft 教程:
http://msdn.microsoft.com/en-us/library/ms141767。 aspx
您可能需要查看几个教程才能获得为您的特定场景创建解决方案的知识。
SSIS 技巧的另一个优秀来源是 Jamie Thomson 的博客。 这个人是一个 SSIS 向导:
http://blogs.conchango.com/jamiethomson/
查看完材料后,如果您需要特定帮助,请随时留言。
There are Microsoft Tutiorials on how to use each Task Component and concept available here:
http://msdn.microsoft.com/en-us/library/ms141767.aspx
You will likely need to review several tutorials in order to aquire the knowledge to create a solution for your specific scenario.
Another excellent source of SSIS tips is Jamie Thomson's Blog. The man is a bit of wizard with SSIS:
http://blogs.conchango.com/jamiethomson/
Once you have had a look over the material, if you require specific assistance then feel free to drop a line.
以下是 Microsoft 关于 ETL 的一些优秀文章/教程:
Here are some good articles/tutorials from Microsoft on ETL:
查看 Sql Server Central 和 Sql Server World 用户组 (SSWUG)网站。 如果您在这两个地方找不到所需的示例/教程/专家,请放弃编码并开始烹饪,因为这些网站都是宝库!
Check out the Sql Server Central and Sql Server World Users' Group (SSWUG) sites. If you can't find the examples/tutorials/experts you need in those two places, give up coding and take up cooking, because those sites are treasure troves!