SSIS creating table but not transferring data

• Sudhir Talwar

  Grasshopper

  Points: 17

  More actions

  October 23, 2008 at 5:03 am

  #125613

  Hi,

  I have SSIS package which connects to Oracle(source) transferring data to SLQServer2005. It creates the required table in :hehe:In SQLServer but does not populate data from oracle - Error is something like connectivity failed .

  Any ideas ?

  Thanks

  Sudhir

• Michael Gerholdt

  SSCommitted

  Points: 1907

  More actions

  October 25, 2008 at 10:44 pm

  #889716

  Try to get a more complete / accurate copy of the error message.

  You must be able to connect both to Oracle and SQL servers if you are reading table structure in Oracle and creating the table on SQL.

  So an exact error message plus any error numbers will be helpful.