Ms Sql Server Technology Discussions

[deals2buy]

[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

[Desamudhuru]

[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

[deals2buy]

[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

[Desamudhuru]

[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

[deals2buy]

[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?

[Desamudhuru]

[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.

[deals2buy]

[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

[deals2buy]

[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/

[Darling999]

oka saari nee text qualifier lo emundoo cheppu, and preview choodu first data ni ela vastundoo excel loo

[deals2buy]

[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?

[Darling999]

[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

[deals2buy]

[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

[Darling999]

[quote name='deals2buy' timestamp='1351608222' post='1302710576']


SSIS packages - types of deployment to Prod
[/quote]

ooh kk eeyala chestaanu kudiritey

[Darling999]

nee daggara SSIS resumes untey pampistaava naaku oka chinna pani undi, SSIS meeda ekkuva ponts unnavi pampinchavaa I wil PM you the Mail ID

[mtkr]

[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