Ms Sql Server Technology Discussions

[SwamyRaRa]

use execute package(20 times in one new package...call each one in sequence in this new package)...then deploy this solution and do schedule or what ever.....u can follow different approaches to solve this.........
[url=http://www.desigifs.com/gifs/2323/ram-charan-teja][img]http://www.desigifs.com/sites/default/files/rcthair.gif[/img][/url]

[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 "XXXXXX"]: 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.....

[Darling999]

[quote name='cool_dude' timestamp='1369351992' post='1303789671']
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 "XXXXXX"]: 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.....
[/quote]

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

[bhas]

[color=#282828][font=helvetica, arial, sans-serif]Friends, [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif] SSIS Interview vundhi... Kunchum real time lo questions emi adugutharo chepandhi...like ssis project (financial client ithe )guruinchi explain cheyamante Ela cheppali..please throw some suggestions....[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]Thanks....[/font][/color]

[Darling999]

[quote name='bhas' timestamp='1369409891' post='1303791796']
[color=#282828][font=helvetica, arial, sans-serif]Friends, [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif] SSIS Interview vundhi... Kunchum real time lo questions emi adugutharo chepandhi...like ssis project (financial client ithe )guruinchi explain cheyamante Ela cheppali..please throw some suggestions....[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]Thanks....[/font][/color]
[/quote]
this is a big question cant answer in small dude... but tue roju ltt cheyyi will post some thing

[cool_dude]

[quote name='DARLING...' timestamp='1369365842' post='1303790138']

go to project properties and set the option runtime64bit to False and then run the package, this should solve your issue.
[/quote]

Nenu SSIS pkg dvara run chestunna bhaiyya..

Nenu SSIS pkg configuration kuda create chesanu(XMl Configuration). even though aa particular oracle oledb connection properties anni select chesthe..final ga anni vastunnayi kani password save avthaledhu...

So nenu Andulo Password explicit ga edit chesi save chesanu...but still I m geting the same issue...

Package Protection propert ni - I made to [b]Encrypt Sensitive With User Key[/b]
Project Properties lo - alterered to Run in 64 bit to [b]FALSE[/b]

...

[Darling999]

[quote name='cool_dude' timestamp='1369781294' post='1303800759']

Nenu SSIS pkg dvara run chestunna bhaiyya..

Nenu SSIS pkg configuration kuda create chesanu(XMl Configuration). even though aa particular oracle oledb connection properties anni select chesthe..final ga anni vastunnayi kani password save avthaledhu...

So nenu Andulo Password explicit ga edit chesi save chesanu...but still I m geting the same issue...

Package Protection propert ni - I made to [b]Encrypt Sensitive With User Key[/b]
Project Properties lo - alterered to Run in 64 bit to [b]FALSE[/b]

...
[/quote]
emaindi mari raaledaaa?

[roome6]

mama need help., nenu MS SQL medha coding cheshtunna but basic one., ivvala vere programmer rasina code chusa, super rasadu mama., in an effiecient way, naku ippati daka konni commands teliyasdhu. like

Declare CURSOR etc, so ila MS Sql gurinchi nerchukovali ante whats the best book or reading resourse we can use., help please, SQL gurinchi motham nerchukovalnundhi baa. so help pls

[Darling999]

[quote name='roome6' timestamp='1371579549' post='1303867015']
mama need help., nenu MS SQL medha coding cheshtunna but basic one., ivvala vere programmer rasina code chusa, super rasadu mama., in an effiecient way, naku ippati daka konni commands teliyasdhu. like

Declare CURSOR etc, so ila MS Sql gurinchi nerchukovali ante whats the best book or reading resourse we can use., help please, SQL gurinchi motham nerchukovalnundhi baa. so help pls
[/quote]
ala anni okey daggara untey andaru aah bukkey konukkuni Microsoft lo joblu chesey vallu, prati topic okko daggara untadi more over nee realtime experience lo use chesevaati valla ekkuva nerchukuntaavu nuvvu. there is no separate book for all at one place.

[roome6]

asala grnl ga ila each and every topic cover ayye book cheppu ba., fundaentals cover chesedhi., vadi code chusanu., chala efficienct ga rasadu, naku konni teliyakapovatam valla different ga rashtunna and not at all efficient., chala bokkalu nake kanipishtunayi.,

[ghazni]

[quote name='roome6' timestamp='1371581280' post='1303867132']
asala grnl ga ila each and every topic cover ayye book cheppu ba., fundaentals cover chesedhi., vadi code chusanu., chala efficienct ga rasadu, naku konni teliyakapovatam valla different ga rashtunna and not at all efficient., chala bokkalu nake kanipishtunayi.,
[/quote]
thats good part.......... data analysis chesi niku ela kavalo ala rayadamey code..... btw pm check chesuko

[victor_raja]

.

[roome6]

Thanks for sharing.

[quote name='ghazni' timestamp='1371584486' post='1303867361']
thats good part.......... data analysis chesi niku ela kavalo ala rayadamey code..... btw pm check chesuko
[/quote]

[vizagpower]

[quote name='roome6' timestamp='1371588962' post='1303867666']
Thanks for sharing.
[/quote]

pm me also

[roome6]

sent