Click here to Skip to main content
15,889,462 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
AnswerRe: Question on dependency of Business Layer with Data Access Layer Pin
Ian Shlasko28-Sep-09 3:21
Ian Shlasko28-Sep-09 3:21 
AnswerRe: Question on dependency of Business Layer with Data Access Layer Pin
Rozis29-Sep-09 4:46
Rozis29-Sep-09 4:46 
GeneralRe: Question on dependency of Business Layer with Data Access Layer Pin
machadogj13-Oct-09 7:39
machadogj13-Oct-09 7:39 
QuestionThe Duct Tape Programmer (aka the squatter) Pin
Thesisus25-Sep-09 5:39
Thesisus25-Sep-09 5:39 
AnswerRe: The Duct Tape Programmer (aka the squatter) Pin
Pete O'Hanlon25-Sep-09 9:38
mvePete O'Hanlon25-Sep-09 9:38 
AnswerRe: The Duct Tape Programmer (aka the squatter) Pin
Paul Conrad13-Oct-09 7:55
professionalPaul Conrad13-Oct-09 7:55 
QuestionDesign a system to Transform source Files to target file. Pin
lucky akky21-Sep-09 20:54
lucky akky21-Sep-09 20:54 
AnswerRe: Design a system to Transform source Files to target file. Pin
Mycroft Holmes27-Sep-09 22:37
professionalMycroft Holmes27-Sep-09 22:37 
I've built many of these and not once have I used a command line interface. I use a service to do timed and repeated processing.

Generally I use a separate staging file/database for each source file/set. I find you can usually group the files into sets which have the same data structure. I also use stored procs to do the processing from the staging tables to the final data table, this may be frowned upon as it is less flexible than a full ETL tool but I find it suits my style.

I ended up with a winforms app that allows the user to configure a file for loading, defining the title and data rows, the delimiter or column widths and create a staging table with varchar fields so I can either BCP or bulk copy into the staging table. I then assign 1 of about 8 procedures to process to the final data table.

BCP in 2005/8 is more fragile than 2000 so I use bulk copy a lot, slower but more robust.



AnswerRe: Design a system to Transform source Files to target file. Pin
puri keemti7-Dec-09 0:43
puri keemti7-Dec-09 0:43 
QuestionPageRank and its mathematics: Explanation needed Pin
kentipsy20-Sep-09 8:41
kentipsy20-Sep-09 8:41 
Answerignore -- repost Pin
Luc Pattyn20-Sep-09 9:11
sitebuilderLuc Pattyn20-Sep-09 9:11 
Questionhow to pass excel application object to automation object? Pin
SRKSHOME17-Sep-09 20:51
SRKSHOME17-Sep-09 20:51 
AnswerRe: how to pass excel application object to automation object? Pin
David Skelly17-Sep-09 22:48
David Skelly17-Sep-09 22:48 
QuestionDesign Pattern Pin
Chiman111-Sep-09 10:02
Chiman111-Sep-09 10:02 
AnswerRe: Design Pattern Pin
Eddy Vluggen13-Sep-09 2:22
professionalEddy Vluggen13-Sep-09 2:22 
GeneralRe: Design Pattern Pin
Chiman118-Sep-09 9:57
Chiman118-Sep-09 9:57 
Questionwhich is the best design or architecture for developing small windows apps using c#? Pin
jarajeshwaran9-Sep-09 8:01
jarajeshwaran9-Sep-09 8:01 
AnswerRe: which is the best design or architecture for developing small windows apps using c#? Pin
Richard MacCutchan13-Sep-09 1:51
mveRichard MacCutchan13-Sep-09 1:51 
AnswerRe: which is the best design or architecture for developing small windows apps using c#? [modified] Pin
Eddy Vluggen13-Sep-09 3:01
professionalEddy Vluggen13-Sep-09 3:01 
Questioncode required Pin
vishwjeet7-Sep-09 10:08
vishwjeet7-Sep-09 10:08 
AnswerRe: code required Pin
Luc Pattyn7-Sep-09 10:44
sitebuilderLuc Pattyn7-Sep-09 10:44 
AnswerRe: code required Pin
Pete O'Hanlon7-Sep-09 11:20
mvePete O'Hanlon7-Sep-09 11:20 
QuestionHow to structure your entities Pin
Mycroft Holmes6-Sep-09 16:27
professionalMycroft Holmes6-Sep-09 16:27 
AnswerRe: How to structure your entities Pin
David Skelly8-Sep-09 2:42
David Skelly8-Sep-09 2:42 
GeneralRe: How to structure your entities Pin
Mycroft Holmes8-Sep-09 14:09
professionalMycroft Holmes8-Sep-09 14:09 

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.