error connecting to ODBC while running the ssis package from command prompt using the DTEXEC

• samnalam

  SSC Journeyman

  Points: 84

  More actions

  July 20, 2016 at 10:45 am

  #328554

  Hi There,

  I am trying to extract the data from oracle to sql server using SSIS package. I have my oracle connection is via ADO NET (ODBC) connection to oracle. The package works perfectly from the visual studio however when i run it from the command prompt using the DTEXEC it throws the following error. what might be the issue? and how to resolve it. Appreciate any help.

  Code: 0xC0047062

  Source: Data Flow Task ADO NET Source [1]

  Description: System.Data.Odbc.OdbcException: ERROR [28000] [Oracle][ODBC][Ora]

  ORA-01005: null password given; logon denied