Timeline for ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Dec 14, 2012 at 22:51 | vote | accept | 8kb | ||
| Dec 14, 2012 at 22:36 | comment | added | billinkc | I have updated my response with thoughts on design and pure tsql ETL approach | |
| Dec 14, 2012 at 22:35 | history | edited | billinkc | CC BY-SA 3.0 |
addressed questions from the comments
|
| Dec 14, 2012 at 21:58 | comment | added | 8kb | BIML looks very interesting. I was also considering creating each data flow as a separate package and then having them called through a master package. Do you think that's any better? Also, curious if you have an opinion on the T-SQL approach. It's slower but I've tested it and it will work. | |
| Dec 14, 2012 at 21:51 | history | answered | billinkc | CC BY-SA 3.0 |