Ms Sql Server Technology Discussions

[deals2buy]

[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

[Darling999]

[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

[deals2buy]

[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]

[Darling999]

[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

[deals2buy]

[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

[Darling999]

[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

[deals2buy]

[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

[deals2buy]

Darling mayya..did u try that?

[mtkr]

[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....)???

[mtkr]

[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???

[chelsea]

[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

[chelsea]

[chelsea]

[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

[Darling999]

[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

[deals2buy]

[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