June 20, 2012 at 12:05 am
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
June 20, 2012 at 9:24 am
When you say you do it from SQL Server, do you mean you use the Export/Import wizard? And if so, do you save it as a package and run it in SSIS?
You can try the Attunity drivers, they're optimized for speed. Of course, make sure to validate your data afterwards.
Check this:
http://msdn.microsoft.com/en-us/library/ee470675(v=sql.100).aspx
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
June 21, 2012 at 10:50 am
DBA_AUS (6/20/2012)
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
Who cares why? use your own code, ditch SSIS on this one.
SSIS is a Microsoft SQL Server tool designed to do amazing things when SQL Server is the target - in this particular case Oracle is the target.
Having said that, if your really want to know "why" then trace the SSIS generated query on Oracle side, check wait events as well as execution plan.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 21, 2012 at 4:57 pm
i created a ssis package. and doing data export from SQL to oracle in data flow task
June 24, 2012 at 7:38 am
Hi,
Use Attunity drivers that you can download from Microsoft's website.
http://www.microsoft.com/en-us/download/search.aspx?q=attunity%20connectors%20for%20oracle
Hope this will help you.
Micrsoft OLEDB for Oracle will have additional layer , which cause the performance issue with non microsoft rdbms.
June 26, 2012 at 1:05 am
Hi,
If you are still having trouble, please send us detailed Problem statement at info@99-consulting.com and we would try to help you out. By the way we also offer Remote DBA Services if you are interested in having these services. Please see its details at http://www.99-consulting.com/node/21
Regards,
99 Consulting (www.99-consulting.com)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply