SwamyRaRa Posted May 20, 2013 Report Share Posted May 20, 2013 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] Link to comment Share on other sites More sharing options...
cool_dude Posted May 23, 2013 Report Share Posted May 23, 2013 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..... Link to comment Share on other sites More sharing options...
Darling999 Posted May 24, 2013 Report Share Posted May 24, 2013 [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. Link to comment Share on other sites More sharing options...
bhas Posted May 24, 2013 Report Share Posted May 24, 2013 [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] Link to comment Share on other sites More sharing options...
Darling999 Posted May 24, 2013 Report Share Posted May 24, 2013 [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 Link to comment Share on other sites More sharing options...
cool_dude Posted May 28, 2013 Report Share Posted May 28, 2013 [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] ... Link to comment Share on other sites More sharing options...
Darling999 Posted May 29, 2013 Report Share Posted May 29, 2013 [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? Link to comment Share on other sites More sharing options...
roome6 Posted June 18, 2013 Report Share Posted June 18, 2013 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 Link to comment Share on other sites More sharing options...
Darling999 Posted June 18, 2013 Report Share Posted June 18, 2013 [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. Link to comment Share on other sites More sharing options...
roome6 Posted June 18, 2013 Report Share Posted June 18, 2013 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., Link to comment Share on other sites More sharing options...
ghazni Posted June 18, 2013 Report Share Posted June 18, 2013 [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 Link to comment Share on other sites More sharing options...
victor_raja Posted June 18, 2013 Report Share Posted June 18, 2013 . Link to comment Share on other sites More sharing options...
roome6 Posted June 18, 2013 Report Share Posted June 18, 2013 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] Link to comment Share on other sites More sharing options...
vizagpower Posted June 18, 2013 Report Share Posted June 18, 2013 [quote name='roome6' timestamp='1371588962' post='1303867666'] Thanks for sharing. [/quote] pm me also Link to comment Share on other sites More sharing options...
roome6 Posted June 18, 2013 Report Share Posted June 18, 2013 sent Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts