Click here to Skip to main content
15,891,473 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
QuestionGood programming practice Pin
tamasu19-Aug-11 7:57
tamasu19-Aug-11 7:57 
AnswerRe: Good programming practice Pin
jschell21-Aug-11 11:03
jschell21-Aug-11 11:03 
QuestionDesign and Architecture is it a secret ?? why people keep hiding ?? Pin
capsulez17-Aug-11 13:08
capsulez17-Aug-11 13:08 
AnswerRe: Design and Architecture is it a secret ?? why people keep hiding ?? Pin
jschell18-Aug-11 12:54
jschell18-Aug-11 12:54 
QuestionIt's mediators all the way down. Pin
Leslie Sanford10-Aug-11 4:48
Leslie Sanford10-Aug-11 4:48 
AnswerRe: It's mediators all the way down. Pin
Pete O'Hanlon10-Aug-11 4:53
mvePete O'Hanlon10-Aug-11 4:53 
AnswerRe: It's mediators all the way down. Pin
jschell10-Aug-11 9:59
jschell10-Aug-11 9:59 
QuestionGeneral Architecture query - SSIS / XML / BizTalk [modified] Pin
bgallagher_lib2-Aug-11 22:18
bgallagher_lib2-Aug-11 22:18 
Hi I am working on a project to process three files...two CSVs and one XML. These files are being moved from a file share to a SQL Server database table using BizTalk. The xml file is being transformed into the same flat file format as the two flat files using a C# component in SSIS. Then, these flat files are processed by SSIS packages. There is a lot of business logic in the SSIS transformations. The SSIS packages also do several look-ups using linked servers. All lookups and transforms are done on a row-by-row basis (which is slow). Also, any errors that occur are put in a separate database table depending on the business object that causes the error (i.e. BusObj1_error, BusObj2_error, BusObj3_error).
Basically, I was hoping someone could suggest a better architecture that would improve performance, allow scalability and flexibility, and allow many developers works as a team on the same pieces of functionality.
E.g.
- Put validation rules in a db rather than hardcoded into SSIS.
- Instead of using different error tables, use a single error table with a errorTypeId FK to an ErrorType table.
- Migrate all transformations from SSIS C# so that multiple developers can work on different Business logic classes at same time.

Thanks

modified on Wednesday, August 3, 2011 5:28 AM

AnswerRe: General Architecture query - SSIS / XML / BizTalk Pin
jschell3-Aug-11 10:16
jschell3-Aug-11 10:16 
GeneralRe: General Architecture query - SSIS / XML / BizTalk Pin
bgallagher_lib4-Aug-11 1:22
bgallagher_lib4-Aug-11 1:22 
GeneralRe: General Architecture query - SSIS / XML / BizTalk Pin
jschell4-Aug-11 8:16
jschell4-Aug-11 8:16 
AnswerRe: General Architecture query - SSIS / XML / BizTalk Pin
Mycroft Holmes4-Aug-11 3:05
professionalMycroft Holmes4-Aug-11 3:05 
GeneralRe: General Architecture query - SSIS / XML / BizTalk Pin
bgallagher_lib4-Aug-11 3:37
bgallagher_lib4-Aug-11 3:37 
GeneralRe: General Architecture query - SSIS / XML / BizTalk Pin
S Douglas25-Aug-11 15:28
professionalS Douglas25-Aug-11 15:28 
QuestionMaster / Detail Datasource design quesiton Pin
David Mujica12-Jul-11 10:47
David Mujica12-Jul-11 10:47 
AnswerRe: Master / Detail Datasource design quesiton Pin
jschell12-Jul-11 10:56
jschell12-Jul-11 10:56 
GeneralRe: Master / Detail Datasource design quesiton Pin
David Mujica13-Jul-11 3:29
David Mujica13-Jul-11 3:29 
GeneralRe: Master / Detail Datasource design quesiton Pin
jschell13-Jul-11 9:00
jschell13-Jul-11 9:00 
GeneralRe: Master / Detail Datasource design quesiton Pin
Mycroft Holmes4-Aug-11 3:13
professionalMycroft Holmes4-Aug-11 3:13 
GeneralRe: Master / Detail Datasource design quesiton Pin
may esguerra22-Aug-11 5:34
may esguerra22-Aug-11 5:34 
AnswerRe: Master / Detail Datasource design quesiton Pin
Nagy Vilmos2-Aug-11 22:41
professionalNagy Vilmos2-Aug-11 22:41 
GeneralThank you Pin
David Mujica3-Aug-11 5:18
David Mujica3-Aug-11 5:18 
QuestionIntegrate CAS and ADFS Pin
_Zorro_9-Jun-11 0:18
professional_Zorro_9-Jun-11 0:18 
QuestionWriting Windows Service to connect to Visual Source Safe and download the code Pin
meeram3952-Jun-11 23:40
meeram3952-Jun-11 23:40 
AnswerRe: Writing Windows Service to connect to Visual Source Safe and download the code Pin
Eddy Vluggen3-Jun-11 0:11
professionalEddy Vluggen3-Jun-11 0:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.