Ms Sql Server Technology Discussions

[lolliman]

[img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img]

[JUJUBI_JULABI]

[quote name='loveindia' timestamp='1366298333' post='1303625930']

2008 r 2005 lo?? 2008 lo inbuilt undi kada..
[/quote]
yup kani those are used only in header or footer not in the body

[Darling999]

[quote name='Kaarthikeya' timestamp='1366044761' post='1303606158']
naa daggara currenlty script task dwaara oka txt file lo naaku kaavalsina specific records ni pull chesi database lo ki load chestunna


but I want to use SQL instead of script task to do the same...

currently
ScriptTask>Deletes records that I dont want itself in the file> Load to database (txt file lo 10 columns unte database lo ki 9 columns ey load chestunna)-this involves file-staging-reporting tables

Future
ela cheste better antaaru using sql?

is it good to add the column to existing staging table or create a new table with all the columns and load data and then to stage table?

PS: performance level lo asking
[/quote]

oka question, nuvvu SSIS lo verey tasks use cheddamankuntunnava lekaa complete ga SQl lo hceddamankuntunanva?? clarity plz

[deals2buy]

[quote name='loveindia' timestamp='1366298283' post='1303625920']
passwords untey ela migrate cheyyalo kuda cheppu... cheppalekapotey cheppu chebrolu vellipotaa...
[/quote]nijamga teleedu bhayya...telisthe cheppadaniki em
[quote name='DARLING...' timestamp='1366298351' post='1303625934']

[b]jagrattalu: First check whether you have same MSDB folders(Wither SQL or File system) are Same,[/b]
[b] During Deployment check the option Do not Save sensitivity data under pkg properties, if your pwd's are [/b]
[b] dynamic.[/b]
[b] Check [/b][b]for the config file locations in both environments to be the same where you would place them.[/b]
[size=4] [/size][b]Check the package configuration settings before assigning them.[/b]

[b]Password's" Keep all your pwds's in variables in DEV, create a config file to capture all those variables using package configurations. if you are deploying place them at correct locations. If DBA is deploying provide him with all the config file you create.[/b]
[b]These should be fine [/b][size=4] [b]I guess.[/b][/size]

[size=4][b]Let me know if any thing else needed[/b][/size]
[/quote][img]http://www.manadb.com/Smileys/default/goodpost.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img]
[quote name='Sdaedalus' timestamp='1366298466' post='1303625947']
GUI lo table medha right click chesi design ki velli add a column

aa otion oakte kanipichatledha or Designers -> Table and database designers feature aa ledha?
[/quote]
to be more specific columns meeda ki velli add a column anukunta kadaa [img]http://www.manadb.com/Smileys/default/sSc_hiding2.gif[/img]
aa option okkate kanipinchatledu...atleast nenu aa option okkadaanikosame chusa mari [img]http://www.manadb.com/Smileys/default/sSc_hiding2.gif[/img]

[deals2buy]

[quote name='BreakingBad' timestamp='1366298536' post='1303625956']
[img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img]
[/quote]lolliman aa?
[quote name='DARLING...' timestamp='1366298733' post='1303625994']

oka question, nuvvu SSIS lo verey tasks use cheddamankuntunnava lekaa complete ga SQl lo hceddamankuntunanva?? clarity plz
[/quote]

no more SSIS man...only SQL and that too SPs

[Darling999]

[quote name='Kaarthikeya' timestamp='1366299119' post='1303626059']
lolliman aa?


no more SSIS man...only SQL and that too SPs
[/quote]
ooh kk let me C then

[ChampakDas]

avasaram ledhu design kotintarvatha direct ga column name add chesi save ante saripodhi
thinking..
[quote name='Kaarthikeya' timestamp='1366299057' post='1303626046']


to be more specific columns meeda ki velli add a column anukunta kadaa [img]http://www.manadb.com/Smileys/default/sSc_hiding2.gif[/img]
aa option okkate kanipinchatledu...atleast nenu aa option okkadaanikosame chusa mari [img]http://www.manadb.com/Smileys/default/sSc_hiding2.gif[/img]
[/quote]

[deals2buy]

[quote name='Sdaedalus' timestamp='1366300063' post='1303626239']
avasaram ledhu design kotintarvatha direct ga column name add chesi save ante saripodhi
thinking..
[/quote]nuvvu cheppedi when creating a new table anukunta

[ChampakDas]

kadu modifying ki kuda...may be we are missing something..
What I did....already created table medha right lcick --> design -last rwo lo entered new column name data type ani set chesa--save anthey
[quote name='Kaarthikeya' timestamp='1366300210' post='1303626265']
nuvvu cheppedi when creating a new table anukunta
[/quote]

[deals2buy]

[quote name='Sdaedalus' timestamp='1366300387' post='1303626292']
kadu modifying ki kuda...may be we are missing something..
What I did....already created table medha right lcick --> design -last rwo lo entered new column name data type ani set chesa--save anthey
[/quote]May be nuvvu use chese version nenu use chese version veremo

All I can see is only 'Modify' on an existing table..and nuvvu cheppina desing lo lage cheyyochu indulo

[Darling999]

[quote name='Sdaedalus' timestamp='1366300063' post='1303626239']
avasaram ledhu design kotintarvatha direct ga column name add chesi save ante saripodhi
thinking..
[/quote]
[quote name='Kaarthikeya' timestamp='1366300210' post='1303626265']
nuvvu cheppedi when creating a new table anukunta
[/quote]
[quote name='Sdaedalus' timestamp='1366300387' post='1303626292']
kadu modifying ki kuda...may be we are missing something..
What I did....already created table medha right lcick --> design -last rwo lo entered new column name data type ani set chesa--save anthey
[/quote]

First option uncheck chesi
then try to add the new field under the design and save. you should be good.

[Darling999]

[quote name='Kaarthikeya' timestamp='1366301217' post='1303626421']
May be nuvvu use chese version nenu use chese version veremo

All I can see is only 'Modify' on an existing table..and nuvvu cheppina desing lo lage cheyyochu indulo
[/quote]

ey version use chestunnav nuvvu? ikkada neeku modify lo field names and datatypes display cheystunnayaa

[deals2buy]

[quote name='DARLING...' timestamp='1366301364' post='1303626439']
First option uncheck chesi
then try to add the new field under the design and save. you should be good.
[/quote]what 1st option?

[quote name='DARLING...' timestamp='1366301458' post='1303626450']

ey version use chestunnav nuvvu? ikkada neeku modify lo field names and datatypes display cheystunnayaa
[/quote]Legacy...ya kanipistunnayi

[Darling999]

[quote name='Kaarthikeya' timestamp='1366301475' post='1303626454']
[b]what 1st option[/b]?

Legacy...ya kanipistunnayi
[/quote]

Tools ..> Options--> Designers--> Prevent changes for table creation: uncheck this and then create the new column later save it.
After your work is done chnage you setting back to nomal.

[deals2buy]

[quote name='DARLING...' timestamp='1366302093' post='1303626547']

Tools ..> Options--> Designers--> Prevent changes for table creation: uncheck this and then create the new column later save it.
After your work is done chnage you setting back to nomal.
[/quote]aa designers eh ledani cheptunna..anyways thanku