lolliman Posted April 18, 2013 Report Posted April 18, 2013 [img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img]
JUJUBI_JULABI Posted April 18, 2013 Report Posted April 18, 2013 [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 Posted April 18, 2013 Report Posted April 18, 2013 [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 Posted April 18, 2013 Report Posted April 18, 2013 [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 Posted April 18, 2013 Report Posted April 18, 2013 [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 Posted April 18, 2013 Report Posted April 18, 2013 [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 Posted April 18, 2013 Report Posted April 18, 2013 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 Posted April 18, 2013 Report Posted April 18, 2013 [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 Posted April 18, 2013 Report Posted April 18, 2013 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 Posted April 18, 2013 Report Posted April 18, 2013 [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 Posted April 18, 2013 Report Posted April 18, 2013 [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 Posted April 18, 2013 Report Posted April 18, 2013 [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 Posted April 18, 2013 Report Posted April 18, 2013 [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 Posted April 18, 2013 Report Posted April 18, 2013 [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 Posted April 18, 2013 Report Posted April 18, 2013 [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
Recommended Posts