deals2buy Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='DARLING...' timestamp='1351189672' post='1302689481'] nenu Bunch of files ni Zip chesi inko folder ki pampinchaali SSIS la neekeminaa telusaa idi ela cheyyaloo.. Zipping of Files [/quote] anntini okate saari pampaala? if so does all those files have similar kind of names? basical ga idi two tasks use chesi cheyyochu 1) Execture Process Task - which uses the winzip.exe application to zip/unzip the files 2) Script Task - where u write some vb.net script to do this task? nee req koddiga exact ga cheppu..nenu eppudu idi try cheyyaledu..but will look around it Link to comment Share on other sites More sharing options...
Darling999 Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='deals2buy' timestamp='1351190167' post='1302689533'] anntini okate saari pampaala? if so does all those files have similar kind of names? basical ga idi two tasks use chesi cheyyochu 1) Execture Process Task - which uses the winzip.exe application to zip/unzip the files 2) Script Task - where u write some vb.net script to do this task? nee req koddiga exact ga cheppu..nenu eppudu idi try cheyyaledu..but will look around it [/quote] 5 files unnayi anukoo with names as Test1 -----Test5 These afiles are in Source folder I need to Move them to Destination Folder in a Zip Format. Ippudu cheppu Link to comment Share on other sites More sharing options...
deals2buy Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='DARLING...' timestamp='1351190392' post='1302689562'] 5 files unnayi anukoo with names as Test1 -----Test5 These afiles are in Source folder I need to Move them to Destination Folder in a Zip Format. Ippudu cheppu [/quote] ok same name unte very easy deeniki basical ga foreach loop task use chestav SSIS lo... aa loop lo file name 1 istav...daanni 5 varaku loop chestav..so ivanni oka daggariki move ayyaka zip cheyyochu or else munde zip chesi move cheyyochu ee link chudu okasari [url="http://www.bidn.com/blogs/ShawnHarrison/ssis/2358/zipping-multiple-files-into-one-archive-in-ssis"]http://www.bidn.com/...archive-in-ssis[/url] Link to comment Share on other sites More sharing options...
Darling999 Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='deals2buy' timestamp='1351190741' post='1302689615'] ok same name unte very easy deeniki basical ga foreach loop task use chestav SSIS lo... aa loop lo file name 1 istav...daanni 5 varaku loop chestav..so ivanni oka daggariki move ayyaka zip cheyyochu or else munde zip chesi move cheyyochu ee link chudu okasari [url="http://www.bidn.com/blogs/ShawnHarrison/ssis/2358/zipping-multiple-files-into-one-archive-in-ssis"]http://www.bidn.com/...archive-in-ssis[/url] [/quote] Third Party Tools Lekundaa Chepppu, Porduction lo use cheyyalemu avi. Script Task use chesi cheyyachu but inka ed9inaa method undaa ani choostunnanu Link to comment Share on other sites More sharing options...
deals2buy Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='DARLING...' timestamp='1351191445' post='1302689728'] Third Party Tools Lekundaa Chepppu, Porduction lo use cheyyalemu avi. Script Task use chesi cheyyachu but inka ed9inaa method undaa ani choostunnanu [/quote] adendi bhayya production lo winzip use cheyyanivvara? poni script task tho cheyyochu ga...naaku telisi ivi rende options mari...emaina kotha method kanuka neeku telisthe ikkada share chey Link to comment Share on other sites More sharing options...
Darling999 Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='deals2buy' timestamp='1351191560' post='1302689746'] adendi bhayya production lo winzip use cheyyanivvara? poni script task tho cheyyochu ga...naaku telisi ivi rende options mari...emaina kotha method kanuka neeku telisthe ikkada share chey [/quote] kaadu nuvvu ichinaa link lo TF compresser task undi adi third party taesk manam .dll install cheyyali. Ala ayitey direct ga winzip task untundi online lo. But fine nenu cheptaa inko method unety kk Link to comment Share on other sites More sharing options...
deals2buy Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='DARLING...' timestamp='1351191644' post='1302689759'] kaadu nuvvu ichinaa link lo TF compresser task undi adi third party taesk manam .dll install cheyyali. Ala ayitey direct ga winzip task untundi online lo. But fine nenu cheptaa inko method unety kk [/quote] aa place lo nuvvvu "Execute Process Task" use chey following the same logic Link to comment Share on other sites More sharing options...
deals2buy Posted October 25, 2012 Report Share Posted October 25, 2012 Darling mayya..did u try that? Link to comment Share on other sites More sharing options...
mtkr Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='DARLING...' timestamp='1351189344' post='1302689437'] eda cheyyudu endi mama ekkada develop chestunnavaooo akkadey aah config file create cheyyi dynamic ga values change cheyyi before you send it to another environment, under which registry you want to do the config files?? [/quote] ade mama aac dynamic ga change cheyyadaniki config file create chestam kada!!! aa config files lo ea type use chesthe best( xml, sql, variable....)??? Link to comment Share on other sites More sharing options...
mtkr Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='deals2buy' timestamp='1351189478' post='1302689455'] seppu mayya...lunch ki poyi vachina [/quote] nen DTS packages create cheyyale mama eppudu.....only SSIS e... SSIS lo vere environment lo package execute cheyyadaniki package configurations create chesi aaa diff envi lo e okka file ne change chestam... so ilaage DTS lo kuda em aina untada diff envi lo package execute cheyyadaniki??? Link to comment Share on other sites More sharing options...
chelsea Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='mtkr' timestamp='1351198025' post='1302690664'] nen DTS packages create cheyyale mama eppudu.....only SSIS e... SSIS lo vere environment lo package execute cheyyadaniki package configurations create chesi aaa diff envi lo e okka file ne change chestam... so ilaage DTS lo kuda em aina untada diff envi lo package execute cheyyadaniki??? [/quote] Hi ba ela vunnavu kotha job vachinadi asalu kanipinchataledu ekkada chesthunavu job ippudu Link to comment Share on other sites More sharing options...
chelsea Posted October 25, 2012 Report Share Posted October 25, 2012 Link to comment Share on other sites More sharing options...
chelsea Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='mtkr' timestamp='1351182540' post='1302688589'] SSIS package configurations lo eadi best and Y?? (tstng kosam adagatle...inf kosam askng) meeru eadi use chestharuuu?? [/quote] ba edi best koncham doubt kani mostly andaru XML Configuration use chestharu Link to comment Share on other sites More sharing options...
Darling999 Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='mtkr' timestamp='1351197814' post='1302690640'] ade mama aac dynamic ga change cheyyadaniki config file create chestam kada!!! aa config files lo ea type use chesthe best( xml, sql, variable....)??? [/quote] adi nee req cheptaaru kada okkoka client ki okko prototype untundi vallu adey follow avtaaru for example TCS vadu only SQl vaadtaadu, Wellsfargo only XML vaadtaadu. Edi ivvakapotey nuvvu XML use hceskooo Link to comment Share on other sites More sharing options...
deals2buy Posted October 25, 2012 Report Share Posted October 25, 2012 [quote name='mtkr' timestamp='1351198025' post='1302690664'] nen DTS packages create cheyyale mama eppudu.....only SSIS e... SSIS lo vere environment lo package execute cheyyadaniki package configurations create chesi aaa diff envi lo e okka file ne change chestam... so ilaage DTS lo kuda em aina untada diff envi lo package execute cheyyadaniki??? [/quote] DTS packages ante Enterprise Manager lo chestaam..andulo anni environments different ga untayi but BIDS which is for SSIS lo ala undadu naaku telisi..u can connect to all environments at one place em variables change cheyyali nuvvu? nuvvu edaina SQL code raastunte kanuka ekkadaina servername mention cheyyalante DECLARE @ServerName VARCHAR(30) SELECT @ServerName = @@SERVERNAME This will work in every environment pointing to the particular server Link to comment Share on other sites More sharing options...
-1.thumb.png.613bdd33b4e8b5f69ac815bf90e62a8b.png)
Recommended Posts