更新时间:2022-10-18 11:08:05
使用
..并且在数据流任务中使用目标
和源
助手,您可以为每个助手定义其自己的连接字符串。
当然,除了这些,您还可以应用所需的任何类型的数据转换。
编辑:
由于您的源是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
: