Ssis Babulu Ekkada Unna Ravalamma..plz

[cool_dude]

I am trying to load the data from ORacle to Sql Server using SSIS

Prob enti ante..

Src OLEDB Connection use chesanu...

So setting chesetappudu anni fine ga unanyi...user name, password icchaka..test connection ante SUCCESSFUl ani vastundi.
I can preview the data..

kani once debug chesthe I'm getting error..


[b]Error at ClarityData [Connection manager "XXXXX"]: 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 Oracle" Hresult: 0x80040E4D Description: "ORA-01017: invalid username/password; logon denied
".

Error at Data Flow Task [OLE DB Source [996]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "XXXXX" failed with error code 0xC0202009.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.[/b]

Connection manager lo password is breaking everytime..compatability kosam ssis ni 32 bit lo run chesanu..still same problem..

Any solutions and suggestions plz.....

[kiladi bullodu]

ltt

[libraguy863]

I think the Ora pwd is not being stored or saved, we can try [color=#333333]PackageProtectionLevel to EncryptSensitiveWithUserKey and see if that works, R u trying to run via agent? in the packge while u r executing need to have the pwd too so (executed from AGENT ).[/color]

[ghazni]

ok sari connection chesetapudu edo ip address untadi advanced connection lo adi match undo ledo chusuko db ki.........

naku antaga teliyadu ssis but just hint............. between LTT

[pachimirchi]

[quote name='libraguy863' timestamp='1369353505' post='1303789750']
I think the Ora pwd is not being stored or saved, we can try [color=#333333]PackageProtectionLevel to EncryptSensitiveWithUserKey and see if that works, R u trying to run via agent? in the packge while u r executing need to have the pwd too so (executed from AGENT ).[/color]
[/quote]
+1.. paina cheppindi work kakapote chimple ga package config set up sey config file create sesko user name and pwd save sey..matter over

[Darling999]

go to project properties and set the option runtime64bit to False and then run the package, this should solve your issue.
try this and let me know?

[mtkr]

[quote name='DARLING...' timestamp='1369365920' post='1303790143']
go to project properties and set the option runtime64bit to False and then run the package, this should solve your issue.
try this and let me know?
[/quote]
already 32 bit lo run chesadanta bayya.....no use...

[mtkr]

bayya oka saari vere provider tho try cheiii..... orcle provdr for m/c

[Darling999]

[quote name='mtkr' timestamp='1369367348' post='1303790220']
already 32 bit lo run chesadanta bayya.....no use...
[/quote]

32 bit lo aah [b]OLE DB Provider for Oracle[/b] undadu bhayya, but 64 lo run chestey untundi and danni(packages) ni teeskochi ikkada run chestey aah issue raadu. 90 % max adey issue ayitey

[mtkr]

chk thz....same issue...


[url="http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/d04ec5d5-156e-4b9c-99aa-479a58c43bb9"]http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/d04ec5d5-156e-4b9c-99aa-479a58c43bb9[/url]

[mtkr]

[quote name='DARLING...' timestamp='1369367539' post='1303790234']
32 bit lo aah [b]OLE DB Provider for Oracle[/b] undadu bhayya, but 64 lo run chestey untundi and danni(packages) ni teeskochi ikkada run chestey aah issue raadu. 90 % max adey issue ayitey
[/quote]
providers ki 32/64 bit ki link endhiii!!! aaa providers irrespective of modes kada!!!!

[Darling999]

[quote name='mtkr' timestamp='1369367896' post='1303790267']
providers ki 32/64 bit ki link endhiii!!! aaa providers irrespective of modes kada!!!!
[/quote]

version of SQl nuvvu use chesey daani batti untundi ani naa meaning, 32 lo max edi use chestaamu? 64 lo installed version ayitey 100% oracle and Teradata providers untaayi kada.

[cool_dude]

Tnq andariki for u r responses....Nenu already lngweekend josh lo unannu..ivvala offc leave pettanu...malli tue roju eey issue ni chustanu.....malli appudu eey thread lift chestanu..Tnq all...

[Darling999]

[quote name='cool_dude' timestamp='1369409441' post='1303791743']
Tnq andariki for u r responses....Nenu already lngweekend josh lo unannu..ivvala offc leave pettanu...malli tue roju eey issue ni chustanu.....malli appudu eey thread lift chestanu..Tnq all...
[/quote]
[img]http://lh4.ggpht.com/-IUiGpNShg_k/USWWVxdHwwI/AAAAAAAAKHU/afUAws2RugE/s150/Brahmi-17.gif[/img]

[cool_dude]

LTT again...

I tried all the options em wrk athalevu..any suggestion guys...