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上的一些好文章/教程:
#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上的一些好文章/教程:
#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)站点。如果你在这两个地方找不到你需要的例子/教程/专家,那就放弃编码并开始做饭,因为这些网站都是宝藏!