CODEWITHSUNDEEP
sql-serveroracle-databasessispackage
Badri Prasad
Badri Prasad

Reputation: 117

SSIS Package for dynamic Souce database

i want to know whether the Following is possible and if so please explain in detail. thanks.

In SQL we have Table1 which has many Oracle server connection details. what we have to do is, we need to copy data from Oracle.Table5 to SQl.Table5. the condition is in SQL.Table5 i know the factory name and using the factory name i can get the oracle server details in SQL.Table1. so using the oracle server details i need to connect to oracle and get the matching data and then update in Sql.Table5. Is this possible in SSIS package?

Thanks in advance.

Upvotes: 0

Views: 1025

Answers (1)

cfrag
cfrag

Reputation: 746

Yes, it is possible to do that in SSIS. One way of doing it is using dynamic connection strings:

http://sql-bi-dev.blogspot.pt/2010/07/dynamic-database-connection-using-ssis.html

http://kevine323.blogspot.pt/2012/04/dynamic-connection-strings-in-ssis.html

This is all the detail i can give you considering the question.

Upvotes: 1

Related Questions