ghazni Posted August 17, 2012 Author Report Posted August 17, 2012 [quote name='DARLING...' timestamp='1345213309' post='1302325640'] Calling ghazni [/quote] yeah chepu mama.......
Bairagi From Bapatla Posted August 17, 2012 Report Posted August 17, 2012 [quote name='DARLING...' timestamp='1345166363' post='1302323267'] What you used to do in previous proj antey? Sol: We had few legacy systems like Oracle, Teradata, and sometimes files like .txt and Excel from users. My role was to get the data from Legacy to our DB using SSIS: Here tell them than you wrote different packages for transfer. After Getting the data we need to transform it according to Business requirements and Logics, these were Implemented in SSIS using different components. Wat have you used from above ani adigitey: in Dataflow: I sued Lookup, ConditionalSplit, File system, Oldeb SOurce and destination for connections, Foreach loop, Mail, Execute SQl in COntrol flow(dont just limit to these but also tell them if you know any more). After the Logics are applied in these Packages, data used to flow into Text files for users. if they ask you: how did you send the files to them, then say you used FTP task for the Transfer to remote location. if they ask you: Any issues while you developed the packages antey tell them dat you had datatype issues as transfer was from different legacies to our systems. regarding components: use this Link for reference yoiu should be good. Ask me if you have any more Questions. I will help you. Note: this is a simple scenario in real time. ATB [/quote] Baa racha lepav po.... Alane inkoni scenarios and emaina manchi videos unte ivvu baa... Nenu SQL server DBA/dev kani old version SQL2000(DTS) use chesthunam maa company lo.... job change avudham anukuntunna help chei baa...
ghazni Posted August 17, 2012 Author Report Posted August 17, 2012 [quote name='Bairagi From Bapatla' timestamp='1345215395' post='1302325889'] Baa racha lepav po.... Alane inkoni scenarios and emaina manchi videos unte ivvu baa... Nenu SQL server DBA/dev kani old version SQL2000(DTS) use chesthunam maa company lo.... job change avudham anukuntunna help chei baa... [/quote] konni scenarios chepta annadu.... and videos kavalntey na dagara unayi kani ela share chesukovalo teliyadu almost oka 50 videos unayi about ssis........
Silver_mani Posted August 17, 2012 Report Posted August 17, 2012 [quote name='DARLING...' timestamp='1345166363' post='1302323267'] What you used to do in previous proj antey? Sol: We had few legacy systems like Oracle, Teradata, and sometimes files like .txt and Excel from users. My role was to get the data from Legacy to our DB using SSIS: Here tell them than you wrote different packages for transfer. After Getting the data we need to transform it according to Business requirements and Logics, these were Implemented in SSIS using different components. Wat have you used from above ani adigitey: in Dataflow: I sued Lookup, ConditionalSplit, File system, Oldeb SOurce and destination for connections, Foreach loop, Mail, Execute SQl in COntrol flow(dont just limit to these but also tell them if you know any more). After the Logics are applied in these Packages, data used to flow into Text files for users. if they ask you: how did you send the files to them, then say you used FTP task for the Transfer to remote location. if they ask you: Any issues while you developed the packages antey tell them dat you had datatype issues as transfer was from different legacies to our systems. regarding components: use this Link for reference yoiu should be good. Ask me if you have any more Questions. I will help you. Note: this is a simple scenario in real time. ATB [/quote] gp baa
Bairagi From Bapatla Posted August 17, 2012 Report Posted August 17, 2012 [quote name='ghazni' timestamp='1345215674' post='1302325923'] konni scenarios chepta annadu.... and videos kavalntey na dagara unayi kani ela share chesukovalo teliyadu almost oka 50 videos unayi about ssis........ [/quote] kudirithe 4shared.com lo upload chei baa...
ghazni Posted August 17, 2012 Author Report Posted August 17, 2012 [quote name='Bairagi From Bapatla' timestamp='1345217080' post='1302326106'] kudirithe 4shared.com lo upload chei baa... [/quote] mama anta peda file cheyocha........ nenu actual ga link idam naukuna kani adi patha project lo na team lead nunchi tisukuna..........
ghazni Posted August 17, 2012 Author Report Posted August 17, 2012 mama anta peda file upload kavadam ledu do u know how to split rar file.........
Bairagi From Bapatla Posted August 17, 2012 Report Posted August 17, 2012 [quote name='ghazni' timestamp='1345217585' post='1302326180'] mama anta peda file upload kavadam ledu do u know how to split rar file......... [/quote] hm ok baa... chudam verela ela pampachooo...
lolliman Posted August 17, 2012 Report Posted August 17, 2012 [quote name='ghazni' timestamp='1345217585' post='1302326180'] mama anta peda file upload kavadam ledu do u know how to split rar file......... [/quote] size enthundi baa?? outbox.com lo upload cheyyu or jumbofiles.com(1gb per file) lo upload cheyyu
ghazni Posted August 17, 2012 Author Report Posted August 17, 2012 [quote name='lolliman' timestamp='1345224818' post='1302327311'] size enthundi baa?? outbox.com lo upload cheyyu or jumbofiles.com(1gb per file) lo upload cheyyu [/quote] almost 1.7gb undi......... do u know how to split rar file......
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts