在SQL Server 2005中创建ETL过程 [英] Creating a ETL process in SQL server 2005

问题描述

大家好，



我有一点询问，我需要你的帮助。

我正在尝试创建一个ETL过程SQL Server 2005，我以前没有做过任何ETL。

我想要的是数据在服务器中可用，我想自动化这个过程，就像ETL应该在特定时间每天运行和每日转储数据应该每天上传到SQL服务器上。

我之前没有这么做过，所以没有多少经验，请你们的任何帮助都会非常感激。



谢谢。



我的尝试：



与网络解决方案混淆

Hello guys,

I have a little query and i need your help.
I am trying to create a ETL Process on SQL Server 2005, i have not made any ETL before.
What i want is data is available in a server and i want to automate the process like the ETL should run daily at a specific time and daily dump of data should get uploaded on SQL server on daily basis.
I have not done this before so not much experience about it, please any help from your end would be much appreciated.

Thank you.

What I have tried:

Confused with the web solutions

推荐答案

这对于这个论坛来说不是一个好问题，因为它太大而且不够具体。



我担心你必须坚持使用在网上找到的教程和文档。以下信息可能对您有所帮助：



您需要使用的工具称为SQL Server Integration Services，简称SSIS。在SQL Server 2005之前，它被称为DTS。您将要在SSIS中设置一些任务来执行您想要的操作，您可以使用SQL代理来自动完成这些任务。



只有官方教程我才能快速找到这个 - SSIS教程：创建一个简单的ETL包 [ ^ ]，但它只能回溯到SQL Server 2008.您可能仍然可以从它中受益，但在CodeProject上也有一些有用的文章可能会有更多的帮助：

SQL Server Integration Services（SSIS） - 第1部分：SSIS和创建包的基础知识 [ ^ ]

如何创建第一个SQL Server Integration Services（SSIS）包 - 第1部分 [ ^ ]



一旦完成了教程，如果你还在苦苦挣扎，那么如果你需要帮助，请回答更具体的问题。

This is not a good question for this forum as it is too large a subject and not specific enough.

I'm afraid you are going to have to persist with the tutorials and documentation you can find on line. The following information might help you though:

The tool you will need to use is called SQL Server Integration Services, or SSIS for short. Prior to SQL Server 2005 it was known as DTS. You are going to want to set up some "Tasks" in SSIS to do what you want and you can use a SQL "Agent" to automate those tasks.

The only "official" tutorial I've been able to locate quickly is this one - SSIS Tutorial: Creating a Simple ETL Package[^], however it only goes back as far as SQL Server 2008. You may still benefit from following it but there are also some useful articles here on CodeProject that might be of more help:
SQL Server Integration Services (SSIS) – Part 1: Basics of SSIS and Creating Packages[^]
How to Create your First SQL Server Integration Services (SSIS) Package - Part 1[^]

Once you have been through the tutorials, if you are still struggling then do come back with more specific questions if you need help.

这篇关于在SQL Server 2005中创建ETL过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！