Ms Sql Server Technology Discussions

[deals2buy]

[quote name='9pardhu' timestamp='1356122483' post='1302996944']


google lo chala vastuai other than xp_cmdshell
[/quote]
naakem kanpinchale...avanni SSIS antunai ga

[ravi87]

[quote name='9pardhu' timestamp='1356122483' post='1302996944']


google lo chala vastuai other than xp_cmdshell
[/quote]
i knw .. one thing.. Using SSIS .. execute Process Task lo.. vellu .......... andulo .. EDIT click chesth.. new window vastadi kada.. THEN ..


General
process
executable ..

endulo.. Process click cheai..................... then .. EXECUTABLE ane column lo .. ne fil epath ivu bas... ( ade ne batch file .bat)

[deals2buy]

[quote name='ravi87' timestamp='1356123536' post='1302997100']
i knw .. one thing.. Using SSIS .. execute Process Task lo.. vellu .......... andulo .. EDIT click chesth.. new window vastadi kada.. THEN ..


General
process
executable ..

endulo.. Process click cheai..................... then .. EXECUTABLE ane column lo .. ne fil epath ivu bas... ( ade ne batch file .bat)
[/quote]
paina clear ga adigaanu kada bhayya using SQL ani...naa daggara SSIS ledu...

[ravi87]

[quote name='Kaarthikeya' timestamp='1356123624' post='1302997113']
paina clear ga adigaanu kada bhayya using SQL ani...naa daggara SSIS ledu...
[/quote]


Agent tho run cheyai.......... batch file ni bas..

ne requiremnt koncham clear ga chepu

[deals2buy]

[quote name='ravi87' timestamp='1356124010' post='1302997161']


Agent tho run cheyai.......... batch file ni bas..

ne requiremnt koncham clear ga chepu
[/quote]


It shud be a part of a Stored procedure....SP lo nundi kuda Agent tho run cheyyocha?

[ravi87]

[quote name='Kaarthikeya' timestamp='1356124074' post='1302997165']


It shud be a part of a Stored procedure....SP lo nundi kuda Agent tho run cheyyocha?
[/quote]


YA Agent tho .......... CMDEXEC option select chesi.. run chreyochu..try it

[deals2buy]

[quote name='ravi87' timestamp='1356124488' post='1302997212']


YA Agent tho .......... CMDEXEC option select chesi.. run chreyochu..try it
[/quote]
ardham kaaledu....ee CMDEXEC anedi SP lo include cheyyocha leka Agent tho ne run cheyyala?

[ravi87]

[quote name='Kaarthikeya' timestamp='1356124985' post='1302997265']
ardham kaaledu....ee CMDEXEC anedi SP lo include cheyyocha leka Agent tho ne run cheyyala?
[/quote]


DUDE... Agent tho set up chestama job ni............ new Job step lo.... TYPE options lo .. drop down chesi chudu kanipistadi........... replication , t-sql , cmdexce ..
ala..

[deals2buy]

[quote name='ravi87' timestamp='1356125422' post='1302997338']


DUDE... Agent tho set up chestama job ni............ new Job step lo.... TYPE options lo .. drop down chesi chudu kanipistadi........... replication , t-sql , cmdexce ..
ala..
[/quote]
ok got it..but naa ETL process lo ee batch file ni execute cheyyadam anedi madhyalo ekkado vastundi...appudu akkada nundi execute cheyyadam kaavali naaku

[ravi87]

[quote name='Kaarthikeya' timestamp='1356125564' post='1302997362']
ok got it..but naa ETL process lo ee batch file ni execute cheyyadam anedi madhyalo ekkado vastundi...appudu akkada nundi execute cheyyadam kaavali naaku
[/quote]


malli ETL antav ante.. indake chepavu kada SSIS ledu ani malli ETL ante. wt do u mean bro

[deals2buy]

[quote name='ravi87' timestamp='1356125746' post='1302997388']


malli ETL antav ante.. indake chepavu kada SSIS ledu ani malli ETL ante. wt do u mean bro
[/quote]
ETL ante only SSIS kaadu ga When u right a SP to perform a series of data loads ,,,thats called ETL too bro

[ravi87]

[quote name='Kaarthikeya' timestamp='1356125855' post='1302997403']
ETL ante only SSIS kaadu ga When u right a SP to perform a series of data loads ,,,thats called ETL too bro
[/quote]



[size=4][background=transparent]ithe edhe dikku anukunta ika....... am nt sure.. xp_CMDShell [/background][/size]

[ravi87]

[quote name='ravi87' timestamp='1356126338' post='1302997460']



[size=4][background=transparent]ithe edhe dikku anukunta ika....... am nt sure.. xp_CMDShell [/background][/size]
[/quote]


Can i see ur code bro.....................

[deals2buy]

[quote name='ravi87' timestamp='1356126338' post='1302997460']



[size=4][background=transparent]ithe edhe dikku anukunta ika....... am nt sure.. xp_CMDShell [/background][/size]
[/quote]
[quote name='ravi87' timestamp='1356126397' post='1302997466']


Can i see ur code bro.....................
[/quote]

monday chupista...going home

[ravi87]

[quote name='Kaarthikeya' timestamp='1356127236' post='1302997626']
monday chupista...going home
[/quote]


Edo timepassing posting aa bro...edo serious prob ani .. ekkada recchipoi answering.. hehe .... ok byee........ tc.................