deals2buy Posted October 29, 2012 Report Share Posted October 29, 2012 [quote name='Desamudhuru' timestamp='1351532317' post='1302705105'] [b] SSIS package nundi oka 32-bit ni Excel loki vasa datani motham data ki apstrophe vochindi danni ela delete cheyali [/b] pllzzzzzz help cheyandi [b] goole chesA KANI CORRECT SOLUTION DORAKLEDU[/b] [/quote] apstrophe ekkada vachindi? koddiga clear ga cheppu mama... [quote name='pawan_bhaktudu' timestamp='1351532641' post='1302705160'] hi nice to meet you all.. my training just completed and i am about to start marketing for my first project [/quote] ATB ...chakkaga chaduko project ki velle mundu..dont depend on others for support [quote name='chelsea' timestamp='1351532760' post='1302705176'] RDL report defination language ba nuvu ssrs report create chesthe it will store as RDL file [/quote] ya ya ..idea undi..but RDL full form marchipoina anthe Link to comment Share on other sites More sharing options...
Desamudhuru Posted October 29, 2012 Report Share Posted October 29, 2012 [quote name='deals2buy' timestamp='1351533040' post='1302705212'] apstrophe ekkada vachindi? koddiga clear ga cheppu mama... [/quote] 20,000 rows vunayi for example na data in SQL deshamudhuru Deals2buy time date ani vundi column lo data adi excel loki vesanu na excel sheet lo data ela kanipisthondi 'deshamuduru 'Deals2buy 'time 'date ani kanipisthondi Link to comment Share on other sites More sharing options...
deals2buy Posted October 29, 2012 Report Share Posted October 29, 2012 [quote name='Desamudhuru' timestamp='1351533441' post='1302705275'] 20,000 rows vunayi for example na data in SQL deshamudhuru Deals2buy time date ani vundi column lo data adi excel loki vesanu na excel sheet lo data ela kanipisthondi 'deshamuduru 'Deals2buy 'time 'date ani kanipisthondi [/quote] ok ok neeku ela kanpinchali ippudu? akkada delimiter set chesuntaav nuvvu columns ki madhyalo excel file ki load chesetappudu..anduke ala vastundochu Link to comment Share on other sites More sharing options...
Desamudhuru Posted October 29, 2012 Report Share Posted October 29, 2012 [quote name='deals2buy' timestamp='1351533653' post='1302705315'] ok ok neeku ela kanpinchali ippudu? akkada delimiter set chesuntaav nuvvu columns ki madhyalo excel file ki load chesetappudu..anduke ala vastundochu [/quote] Delimiter em set cheyadam ledu bhayya. Naku data without apostrophe kavali Link to comment Share on other sites More sharing options...
deals2buy Posted October 29, 2012 Report Share Posted October 29, 2012 [quote name='Desamudhuru' timestamp='1351533895' post='1302705354'] Delimiter em set cheyadam ledu bhayya. Naku data without apostrophe kavali [/quote] naa daggara currently tool ki access ledu..what r u exactly doing? Source Connection OLED teesukoni , Excel Destination connection teesukoni just execute chestunnava or else u r doing anything in addition? Link to comment Share on other sites More sharing options...
Desamudhuru Posted October 29, 2012 Report Share Posted October 29, 2012 [quote name='deals2buy' timestamp='1351535397' post='1302705566'] naa daggara currently tool ki access ledu..what r u exactly doing? Source Connection OLED teesukoni , Excel Destination connection teesukoni just execute chestunnava or else u r doing anything in addition? [/quote] Yeah dng the same kani 64-bit accept cheyadam ledu ante danni 32-bit ki marchanu adi only change i did. Link to comment Share on other sites More sharing options...
deals2buy Posted October 29, 2012 Report Share Posted October 29, 2012 [quote name='Desamudhuru' timestamp='1351535658' post='1302705614'] Yeah dng the same kani 64-bit accept cheyadam ledu ante danni 32-bit ki marchanu adi only change i did. [/quote] aa ippudu gurthochindi...64bit daaniki edo setting change cheyyali this is the thing u need to do: if you run the package in BIDS, go to solution explorer, right click on project, select properties go to debugging tab, and set Run64BitRuntime to false this runs the package in 32-bit...try it and let me know Link to comment Share on other sites More sharing options...
deals2buy Posted October 30, 2012 Report Share Posted October 30, 2012 [b] UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL[/b] http://blog.sqlauthority.com/2012/10/30/sql-server-union-all-and-order-by-how-to-order-table-separately-while-using-union-all/ Link to comment Share on other sites More sharing options...
Darling999 Posted October 30, 2012 Report Share Posted October 30, 2012 oka saari nee text qualifier lo emundoo cheppu, and preview choodu first data ni ela vastundoo excel loo Link to comment Share on other sites More sharing options...
deals2buy Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='DARLING...' timestamp='1351607989' post='1302710553'] oka saari nee text qualifier lo emundoo cheppu, and preview choodu first data ni ela vastundoo excel loo [/quote] monna edo chepta ani cheppaledendi vayya? Link to comment Share on other sites More sharing options...
Darling999 Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='deals2buy' timestamp='1351608077' post='1302710565'] monna edo chepta ani cheppaledendi vayya? [/quote] asaslu em cheptaa annanu nenu?? Nijanga gurthu vastalledu [img]https://lh3.googleusercontent.com/-7b15iI4zmYg/TWAgXprYLuI/AAAAAAAAB-I/VqgHZZeu-mA/s150/brahmi%2520laugh.gif[/img] oka saari topic cheppu I will post today Link to comment Share on other sites More sharing options...
deals2buy Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='DARLING...' timestamp='1351608146' post='1302710568'] asaslu em cheptaa annanu nenu?? Nijanga gurthu vastalledu [img]https://lh3.googleusercontent.com/-7b15iI4zmYg/TWAgXprYLuI/AAAAAAAAB-I/VqgHZZeu-mA/s150/brahmi%2520laugh.gif[/img] oka saari topic cheppu I will post today [/quote] SSIS packages - types of deployment to Prod Link to comment Share on other sites More sharing options...
Darling999 Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='deals2buy' timestamp='1351608222' post='1302710576'] SSIS packages - types of deployment to Prod [/quote] ooh kk eeyala chestaanu kudiritey Link to comment Share on other sites More sharing options...
Darling999 Posted October 30, 2012 Report Share Posted October 30, 2012 nee daggara SSIS resumes untey pampistaava naaku oka chinna pani undi, SSIS meeda ekkuva ponts unnavi pampinchavaa I wil PM you the Mail ID Link to comment Share on other sites More sharing options...
mtkr Posted October 30, 2012 Report Share Posted October 30, 2012 [quote name='Desamudhuru' timestamp='1351533441' post='1302705275'] 20,000 rows vunayi for example na data in SQL deshamudhuru Deals2buy time date ani vundi column lo data adi excel loki vesanu na excel sheet lo data ela kanipisthondi 'deshamuduru 'Deals2buy 'time 'date ani kanipisthondi [/quote] ///////////deshamudhuru Deals2buy time date//////////////////// idi antha oke single column lo data naa!!!! or diff columns aaa??? oka sari excel file ni copy chesukoni aaa column format change chesi chuduu Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts