January 12, 2011 at 2:52 am
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
January 12, 2011 at 3:07 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply