AdventureWorks 的 SQL Server 集成服务教程 > AdventureWorksDW 导出

发布于 2024-09-24 00:19:51 字数 637 浏览 1 评论 0原文

我正在开始使用 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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

醉城メ夜风 2024-10-01 00:19:51

这似乎正是 Codeplex 上第一个包的作用:

AWDataWarehouseRefresh 示例包演示了如何使用 AdventureWorks 数据库中的数据在新的 AdvWorksDWX 数据库中创建和填充用户表。

你尝试过运行它吗?

我不想听起来很刺耳,但是您已经有了示例数据库、示例代码和一本关于使用 SSIS 的书,所以我不太确定为什么您无法开始使用。您读过这本书并安装、执行并理解了一些示例包吗?如果没有,我建议您尝试一下,然后回来询问您遇到的具体问题。不幸的是,现在很难知道该建议什么:这不是解释基本概念的合适论坛,但它是回答特定问题的绝佳论坛。

That seems to be exactly what the first package on Codeplex does:

The AWDataWarehouseRefresh sample package illustrates how to create and populate user tables in the new AdvWorksDWX database, using data from the AdventureWorks database.

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.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文