asked on

SSIS Issue : OLE DB connection

Hi,

I want to create a dtsx package to transfer data from a SQL Server database to an oracle database.

I want to define the OLE Db Connection in a external file (Server Name, ODBC Name, User...) and call this package from a VS Windows Forms application with the information defined in this file. Can you help me please?

Thanks fopr your help.

ASKER CERTIFIED SOLUTION

tigin44

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

AngieWill

ASKER

I am new with SSIS.
Do you have perhaps a sample?

Thanks for your answer.

tigin44

current I dont have an example which I can share... You may find out many over internet. Also you can find out detatiled information about configuration files.

Reza Rad

create a ssis package
add a data flow task
add a oledb data source and connect it to sql server
add a oledb data destination , connect it to oracle, remember select oracle provider for this

Reza Rad

you can read all thing from your file with script task and dynamically set expression property to your oledb connection manager
also you can use a configuration file instead that , for any configuration connection

AngieWill

ASKER

Ok I search an example in internet,

Thank for your answer.

SOLUTION

rajvja

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Reza Rad

membership