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
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 export/import error

Author  Topic 

lg123
Starting Member

8 Posts

Posted - 2013-01-28 : 15:25:20
I am trying to load tables from sql server to oracle. Only 2 tables could be loaded successfully. Remaining tables failed. I have attached the error messages below.



James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-28 : 15:53:37
LG, I am not able to see the images you have attached - and I am not behind any firewall or corporate wall, so I think others may not be able to see it as well.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-29 : 03:55:06
please post images in some shared server and put link here

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

Go to Top of Page

lg123
Starting Member

8 Posts

Posted - 2013-01-29 : 10:53:32
Error 1 :

An error occurred which the SQL Server Integration services wizard was not prepared to handle.

Additional Information :

The parameter is incorrect (System.Drawing)



Error 2 :

"Content Type" NVA... failed with the following error: "ORA-00972: identifier is too long". Possible failure reasons:

Problems with the Query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established

correctly.
Go to Top of Page

lg123
Starting Member

8 Posts

Posted - 2013-01-29 : 10:56:32
I had some problem in posting the images. Thus, I had typed in the error messages I received in my previous post.
Go to Top of Page
   

- Advertisement -