使用SSIS将数据从一个数据库复制到另一个数据库 [英] Copying data from one database to another using SSIS
问题描述
我正在编写一个SSIS包,并尝试将数据从一个数据库提取到另一个数据库。我创建了一个Execute SQL任务,并使用以下语句INSERT INTO dbo.getParties EXEC dbo.getParties来执行该操作。当源和目标在同一数据库中时,此方法有效。当源和目标位于不同的数据库中时,该如何处理。您只能将一个连接管理器关联到一个任务。
我是否连接到源并在SP中调用目标?这是正确的方法吗?
下面是我的模板的设计
使用
..并且在数据流任务中使用目标
和源
助手,您可以为每个助手定义其自己的连接字符串。
当然,除了这些,您还可以应用所需的任何类型的数据转换。
编辑:
由于您的源是SQL Command(存储过程),因此需要在源$ c中定义它$ c>助手。如您所见,只需将
数据访问模式
更改为 SQL命令
并设置为 EXEC getParties
:
I am writing a SSIS package and trying to extract the data from one database to another. I have created a Execute SQL task and using the following statement INSERT INTO dbo.getParties EXEC dbo.getParties to perform the operation. This works when the source and destination our in the same database. How do I handle this when the source and destination are in different databases. You can associate only one connection manager to a task.
Do I connect to the source and in the SP call the destination. Is it the right way of doing it
Below is the design of my template
Use Data Flow component where you can set up the source and destination connection strings.
..and inside the data flow task use the Destination
and Source
Assistants that let you define its own connection string for each.
Of course, besides these you can also apply any sort of data transformations you wish.
Edit:
Since you your source is SQL Command (stored procedure) you need to define it in your source
assistant. As you can see here, just change Data Access Mode
to SQL Command
and set to EXEC getParties
:
这篇关于使用SSIS将数据从一个数据库复制到另一个数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!