deals2buy Posted December 21, 2012 Report Share Posted December 21, 2012 [quote name='9pardhu' timestamp='1356122483' post='1302996944'] google lo chala vastuai other than xp_cmdshell [/quote] naakem kanpinchale...avanni SSIS antunai ga Link to comment Share on other sites More sharing options...
ravi87 Posted December 21, 2012 Report Share Posted December 21, 2012 [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) Link to comment Share on other sites More sharing options...
deals2buy Posted December 21, 2012 Report Share Posted December 21, 2012 [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... Link to comment Share on other sites More sharing options...
ravi87 Posted December 21, 2012 Report Share Posted December 21, 2012 [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 Link to comment Share on other sites More sharing options...
deals2buy Posted December 21, 2012 Report Share Posted December 21, 2012 [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? Link to comment Share on other sites More sharing options...
ravi87 Posted December 21, 2012 Report Share Posted December 21, 2012 [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 Link to comment Share on other sites More sharing options...
deals2buy Posted December 21, 2012 Report Share Posted December 21, 2012 [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? Link to comment Share on other sites More sharing options...
ravi87 Posted December 21, 2012 Report Share Posted December 21, 2012 [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.. Link to comment Share on other sites More sharing options...
deals2buy Posted December 21, 2012 Report Share Posted December 21, 2012 [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 Link to comment Share on other sites More sharing options...
ravi87 Posted December 21, 2012 Report Share Posted December 21, 2012 [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 Link to comment Share on other sites More sharing options...
deals2buy Posted December 21, 2012 Report Share Posted December 21, 2012 [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 Link to comment Share on other sites More sharing options...
ravi87 Posted December 21, 2012 Report Share Posted December 21, 2012 [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] Link to comment Share on other sites More sharing options...
ravi87 Posted December 21, 2012 Report Share Posted December 21, 2012 [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..................... Link to comment Share on other sites More sharing options...
deals2buy Posted December 21, 2012 Report Share Posted December 21, 2012 [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 Link to comment Share on other sites More sharing options...
ravi87 Posted December 21, 2012 Report Share Posted December 21, 2012 [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................. Link to comment Share on other sites More sharing options...
21
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts