Sql Server 2008 Integration Server and ODBC for Oracle

• mysaes_jgo

  SSC Veteran

  Points: 262

  More actions

  January 12, 2011 at 2:52 am

  #245165

  I need to move some information from Oracle 8 to Sql Server 2008. I dont have the way to connect other way but only "ODBC". For that matter i created a DSN using

  %SystemRoot%\SysWOW64\odbcad32.exe

  Them on the Integration Service package i used

  uid=gai_hseq;pwd=passw012;Dsn=Oracle;

  When i run the packaged inside Integration Server it runs fine.

  But i need to created a Job to Execute everyday. I change the connection on DataSource inside the Step job like this uid=gai_hseq;pwd=passw012;Dsn=Oracle; . But when i execute the job. i got this error

  Source: Incidentes Connection manager "Oracle" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D Description: "Login failed for user 'gai_hseq'.". An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D Description: "Invalid connection string attribute". End Error

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  Follow

  January 12, 2011 at 3:07 am

  #1272247

  Please don't cross post. It just wastes people's time and fragments replies

  No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1046340-1044-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass