Ms Sql Server Technology Discussions

[mtkr]

[quote name='chelsea' timestamp='1351198398' post='1302690721']

Hi ba ela vunnavu kotha job vachinadi asalu kanipinchataledu ekkada chesthunavu job ippudu
[/quote]
job unte active e undetodini ga mama!!! adi leke ravatle sarigaaa....

nen fne mama...u??marketing aitundhiii

[mtkr]

[quote name='DARLING...' timestamp='1351198564' post='1302690745']

adi nee req cheptaaru kada okkoka client ki okko prototype untundi vallu adey follow avtaaru for example TCS vadu only SQl vaadtaadu, Wellsfargo only XML vaadtaadu. Edi ivvakapotey nuvvu XML use hceskooo
[/quote]
manam TL kakapothe edi cheyyalanukunna vallu cheppindhe cheyyaliii...

kani intw's lo ala cheppalem kada mama..... incase cheppina ne exp lo eadi best ani anukuntunnav ante??

[mtkr]

[quote name='chelsea' timestamp='1351198537' post='1302690740']

ba edi best koncham doubt kani mostly andaru XML Configuration use chestharu
[/quote]
ya mama nen be lst proj lo ade used kani Y ani thnkng!!

[deals2buy]

[quote name='mtkr' timestamp='1351199142' post='1302690838']
manam TL kakapothe edi cheyyalanukunna vallu cheppindhe cheyyaliii...

kani intw's lo ala cheppalem kada mama..... incase cheppina ne exp lo eadi best ani anukuntunnav ante??
[/quote]
ala edi best ani adighte I would personally prefer this because this works very well ani seppu mama
..inka em cheppala ani alochiste ela?

monna konni requirements post chesa DB lo...avi try chesava? eppati nundi ledu neeku job?

[mtkr]

[quote name='deals2buy' timestamp='1351198598' post='1302690751']


DTS packages ante Enterprise Manager lo chestaam..andulo anni environments different ga untayi

but BIDS which is for SSIS lo ala undadu naaku telisi..u can connect to all environments at one place

em variables change cheyyali nuvvu? nuvvu edaina SQL code raastunte kanuka ekkadaina servername mention cheyyalante

DECLARE @ServerName VARCHAR(30)

SELECT @ServerName = @@SERVERNAME


This will work in every environment pointing to the particular server
[/quote]


code lo aithe ettago atla manage cheyyochu mama...

kani package lvl lo aithe...SSIS lo dev lo crte chesthe dev server ki point chestam... same package prod lo execute cheyyali ante prod svr ki point ayyela change cheyyaliii.... adi through package configuration chestam...

so atlane DTS lo kuda cheyyalaa?? or dev lo n prod lo separate ga packages create cheyyalaa??

[deals2buy]

[quote name='mtkr' timestamp='1351199804' post='1302690926']


code lo aithe ettago atla manage cheyyochu mama...

kani package lvl lo aithe...SSIS lo dev lo crte chesthe dev server ki point chestam... same package prod lo execute cheyyali ante prod svr ki point ayyela change cheyyaliii.... adi through package configuration chestam...

so atlane DTS lo kuda cheyyalaa?? or dev lo n prod lo separate ga packages create cheyyalaa??
[/quote]


avuna? nenu as it is ga dev lo develop chesina dts file ni monna QA ki pampincha [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] adi bisket aithada endi ippudu? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]

[Darling999]

[quote name='mtkr' timestamp='1351199142' post='1302690838']
manam TL kakapothe edi cheyyalanukunna vallu cheppindhe cheyyaliii...

kani intw's lo ala cheppalem kada mama..... incase cheppina ne exp lo eadi best ani anukuntunnav ante??
[/quote]

Nenu Ayitey ee Q'n ki two options istaa vaadiki

1. I use Environmental variable Which Gives you Flexibity of Lower Stake when comes to Configuration.
2. You can also use XML Configuration if you have less Number of Packages i.e. Around 50 for one Shot.

In First Case All the Packages Adopt the Environment
In the Second one you need to configure For all of them based on Req.

[deals2buy]

[quote name='DARLING...' timestamp='1351200116' post='1302690966']

Nenu Ayitey ee Q'n ki two options istaa vaadiki

1. I use Environmental variable Which Gives you Flexibity of Lower Stake when comes to Configuration.
2. You can also use XML Configuration if you have less Number of Packages i.e. Around 50 for one Shot.

In First Case All the Packages Adopt the Environment
In the Second one you need to configure For all of them based on Req.
[/quote]

[mtkr]

[quote name='DARLING...' timestamp='1351200116' post='1302690966']

Nenu Ayitey ee Q'n ki two options istaa vaadiki

1. I use Environmental variable Which Gives you Flexibity of Lower Stake when comes to Configuration.
2. You can also use XML Configuration if you have less Number of Packages i.e. Around 50 for one Shot.

In First Case All the Packages Adopt the Environment
In the Second one you need to configure For all of them based on Req.
[/quote]
ide xpectng..... itlaage migitha vatiki kuda em aina comparison cheyyochaa!!!

[Darling999]

[quote name='deals2buy' timestamp='1351200281' post='1302690986']

[/quote]
welcome Welcome

[mtkr]

[quote name='deals2buy' timestamp='1351199299' post='1302690858']
ala edi best ani adighte I would personally prefer this because this works very well ani seppu mama
..inka em cheppala ani alochiste ela?

monna konni requirements post chesa DB lo...avi try chesava? eppati nundi ledu neeku job?
[/quote]
ya chustunna mama....
1.5 mth

[mtkr]

[quote name='deals2buy' timestamp='1351199932' post='1302690939']


avuna? nenu as it is ga dev lo develop chesina dts file ni monna QA ki pampincha [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] adi bisket aithada endi ippudu? [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
[/quote]

aa tst ollu chg chesukuntaru emooo..

[deals2buy]

[quote name='DARLING...' timestamp='1351200339' post='1302690994']
welcome Welcome
[/quote]environmental variable ela set chestav?
[quote name='mtkr' timestamp='1351200342' post='1302690996']
ya chustunna mama....
1.5 mth
[/quote]
ekkada nuvvu undedi?

[Darling999]

[quote name='mtkr' timestamp='1351200322' post='1302690993']

ide xpectng..... itlaage migitha vatiki kuda em aina comparison cheyyochaa!!!
[/quote]
Ya cheppachu mama, But this wud be relaiable Google cheyyi migatha vaatiki oka saari You would find many more. Eminaa Doubt untey ee Taadu ni Lepu I will Ans you

[deals2buy]

[quote name='mtkr' timestamp='1351200380' post='1302690999']

aa tst ollu chg chesukuntaru emooo..
[/quote]
bokka cheskuntaru..maa tester gaadu nannu saava thengutadu aithe next week [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]