SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 ssis package so slow-coping table from sql 2 oracl		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AustraliaDBA
Starting Member

29 Posts
Posted - 06/20/2012 :  02:00:15  Show Profile  Reply with Quote
Hi All,

all i am trying to do is copy data from a table from SQL Server to Oracle. table has 5000 rows only but ssis package takes ages to complete the task. any idea why is it so. if i do the same from sql to sql it takes less than couple of mins. please help

Thanks

yosiasz
Flowing Fount of Yak Knowledge

USA
1610 Posts
Posted - 06/20/2012 :  10:31:32  Show Profile  Click to see yosiasz's MSN Messenger address  Reply with Quote
1. where is the oracle table located: remote or local
2. does the oracle table have embedded logic such as triggers etc

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Edited by - yosiasz on 06/20/2012 11:46:29
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
48076 Posts
Posted - 06/20/2012 :  22:46:57  Show Profile  Reply with Quote
whats the task you're using? are you doing it in control or data flow? is there some transformations involved in between or is it a straight move?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Edited by - visakh16 on 06/20/2012 22:47:48
Go to Top of Page

AustraliaDBA
Starting Member

29 Posts
Posted - 06/21/2012 :  18:55:58  Show Profile  Reply with Quote
oracle database is on seperate server but both sql and oracle db servers are on same domain. i am only changing datatype in data conversion nothing else. i am doing everything in data flow task

Thanks
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
48076 Posts
Posted - 06/21/2012 :  20:00:18  Show Profile  Reply with Quote
are you using fast load option?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

AustraliaDBA
Starting Member

29 Posts
Posted - 06/22/2012 :  00:31:34  Show Profile  Reply with Quote
my source is sql and destination is oracle. at destination i can't see fast load option

Thanks
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
48076 Posts
Posted - 06/22/2012 :  23:04:46  Show Profile  Reply with Quote
oh ok destination is oracle. I thought its other way around.

if its just a direct pull with only data conversions in between why not do it in T-sql scripts by adding Oracle as a linked server and using

INSERT ..SELECT.



------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000