针对ETL的良好SQL Server Integration Services(SSIS)示例/示例的建议?

时间:2021-11-14 17:16:37

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.

我正在寻找一些体面的例子/样本使用SSIS从一个SQL Server数据库到另一个不一定在同一个实例中的ETL。

The idea is to migrate rows of data with their heirarchies (relationships) from one OLTP database to another.

我们的想法是将数据行与其heirarchies(关系)从一个OLTP数据库迁移到另一个OLTP数据库。

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).

SSIS为我们提供了一些优势,使其成为迁移/ ETL平台的一个很好的选择(除此之外,它需要完全可配置并且能够在自动化的时间表上执行)。

Does anyone know of any decent samples/examples besides the MS community samples (on Codeplex)?

除了MS社区样本(在Codeplex上),有没有人知道任何体面的样本/示例?

Edit: I've also had a look at http://www.sqlis.com/ though I haven't found exactly what I'm looking for..

编辑:我也看过http://www.sqlis.com/虽然我还没找到我正在寻找的东西..

3 个解决方案

#1


There are Microsoft Tutiorials on how to use each Task Component and concept available here: http://msdn.microsoft.com/en-us/library/ms141767.aspx

有关如何使用每个任务组件和概念的Microsoft Tutiorials: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:

另一个SSIS技巧的优秀来源是Jamie Thomson的博客。这个男人是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.

一旦您查看了材料,如果您需要特殊帮助,请随时删除一条线。

#2


Here are some good articles/tutorials from Microsoft on ETL:

以下是Microsoft在ETL上的一些好文章/教程:

  1. http://technet.microsoft.com/en-us/library/ms169917.aspx
  2. http://msdn.microsoft.com/en-us/library/cc671624.aspx

#3


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!

查看Sql Server Central和Sql Server World用户组(SSWUG)站点。如果你在这两个地方找不到你需要的例子/教程/专家,那就放弃编码并开始做饭,因为这些网站都是宝藏!

#1


There are Microsoft Tutiorials on how to use each Task Component and concept available here: http://msdn.microsoft.com/en-us/library/ms141767.aspx

有关如何使用每个任务组件和概念的Microsoft Tutiorials: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:

另一个SSIS技巧的优秀来源是Jamie Thomson的博客。这个男人是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.

一旦您查看了材料,如果您需要特殊帮助,请随时删除一条线。

#2


Here are some good articles/tutorials from Microsoft on ETL:

以下是Microsoft在ETL上的一些好文章/教程:

  1. http://technet.microsoft.com/en-us/library/ms169917.aspx
  2. http://msdn.microsoft.com/en-us/library/cc671624.aspx

#3


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!

查看Sql Server Central和Sql Server World用户组(SSWUG)站点。如果你在这两个地方找不到你需要的例子/教程/专家,那就放弃编码并开始做饭,因为这些网站都是宝藏!