AdventureWorks 的 SQL Server 集成服务教程 > AdventureWorksDW 导出
我正在开始使用 MS 技术构建商业智能系统。 我没有任何集成服务或分析服务的经验,因此学习曲线对我来说非常陡峭。
我一直在寻找示例和教程,并发现了一些不错的东西,例如:
- AdventureWorksDW 数据仓库,它将帮助我构建自己的数据仓库。
- 一个不错的 BIDS(商业智能开发工作室)示例项目,用于对
AdventureWorksDW
进行分析。 - http://msftisprodsamples.codeplex.com/ 上的集成服务示例
但我实际上要寻找的是一个示例 BIDS 集成服务项目,它将更改从主 AdventureWorks DB
导出到 AdventureWorksDW DB
。
我似乎在示例中没有找到这样的项目。
或者是否有任何其他可用的教程/视频包含将数据复制到仓库的分步演练?
我有《MS SQL Server 2008 Integration Services Unleashed》一书,但我不知道如何开始。
谢谢。
I'm getting started with building a Business Intelligence system using MS technologies.
I don't have any experience with Integration Services or with Analysis Services, so the learning curve is pretty steep for me.
I have been looking for samples and tutorials and found some nice stuff such as:
- The
AdventureWorksDW
data warehouse, which will help me build my own data warehouse. - A nice BIDS (Business Intelligence Development Studio) sample project for putting analysis on the
AdventureWorksDW
. - Integration Services samples on http://msftisprodsamples.codeplex.com/
But what I'm actually looking for is a sample BIDS Integration Services project that exports changes from the main AdventureWorks DB
into the AdventureWorksDW DB
.
I don't seem to find such project in the samples..
Or is there any other tutorial/video available that contains a step-by-step walktrough on copying data to your warehouse?
I have the book "MS SQL Server 2008 Integration Services Unleashed" but I don't know how to get started.
Thank you.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
这似乎正是 Codeplex 上第一个包的作用:
你尝试过运行它吗?
我不想听起来很刺耳,但是您已经有了示例数据库、示例代码和一本关于使用 SSIS 的书,所以我不太确定为什么您无法开始使用。您读过这本书并安装、执行并理解了一些示例包吗?如果没有,我建议您尝试一下,然后回来询问您遇到的具体问题。不幸的是,现在很难知道该建议什么:这不是解释基本概念的合适论坛,但它是回答特定问题的绝佳论坛。
That seems to be exactly what the first package on Codeplex does:
Have you tried running it?
I don't want to sound harsh, but you already have sample databases, sample code and a book on using SSIS so I'm not really sure why you're unable to get started. Have you read the book and installed, executed and understood a few sample packages? If not, I suggest that you give it a try, then come back and ask about specific problems you're having. Unfortunately it's hard to know what to suggest right now: this isn't a suitable forum for explaining basic concepts, but it is a great forum for answering specific questions.