deals2buy Posted December 21, 2012 Report 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
ravi87 Posted December 21, 2012 Report 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)
deals2buy Posted December 21, 2012 Report 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...
ravi87 Posted December 21, 2012 Report 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
deals2buy Posted December 21, 2012 Report 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?
ravi87 Posted December 21, 2012 Report 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
deals2buy Posted December 21, 2012 Report 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?
ravi87 Posted December 21, 2012 Report 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..
deals2buy Posted December 21, 2012 Report 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
ravi87 Posted December 21, 2012 Report 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
deals2buy Posted December 21, 2012 Report 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
ravi87 Posted December 21, 2012 Report 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]
ravi87 Posted December 21, 2012 Report 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.....................
deals2buy Posted December 21, 2012 Report 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
ravi87 Posted December 21, 2012 Report 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.................
Recommended Posts