sql server to oracle - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

sql server to oracle

Author

Topic

Anand.A
Posting Yak Master

109 Posts

Posted - 2012-01-12 : 04:28:54

Hi

i create a package in ssis..by using this package i take a data from excel then load that to sql server..now i want to do this same job but i want to load data to oracle..in ssis package i can change servername and databasename in sql server...but is there any way to change sql server to oracle server in ssis

anand

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-01-12 : 04:36:19

yep...create a new connection manager to connect to the oracle server and use it to configure your oledb destination task so as to do insertion to oracle server

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Anand.A
Posting Yak Master

109 Posts

Posted - 2012-01-12 : 04:39:39

ya thanks for ur reply.but in my project i am using more than 100 destination and execute sql task so each one i cant change

anand

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2012-01-12 : 11:28:41

quote:
Originally posted by Anand.A

ya thanks for ur reply.but in my project i am using more than 100 destination and execute sql task so each one i cant change

anand

Can't or don't want to?

X002548
Not Just a Number

15586 Posts

Posted - 2012-01-12 : 11:30:24

Save the data as pipe delimited text and use sqlloader to Oracle staging tables

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-01-12 : 12:27:45

quote:
Originally posted by Anand.A

ya thanks for ur reply.but in my project i am using more than 100 destination and execute sql task so each one i cant change

anand

then another way is to make connection string of connection manager as a configurable item by storing it in XML file/SQL table and then changing its value from outside

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources