Viewing 15 posts - 1 through 15 (of 32 total)
Well, this is a big one (for this data set), at ~200-450K rows. So, maybe not _tiny_, but certainly not huge, compared to a lot of others out there.
August 16, 2019 at 1:38 am
Lookup to determine new / existing, conditional split for changed / unchanged, and and OLE DB Command for the actual update, like all the other data flows in the ETL....
August 16, 2019 at 12:53 am
Trying to narrow the problem down, but a rough outline of the overall process is:
August 16, 2019 at 12:23 am
With some additional tweaks and improvements, the version that's using a staging table is running in about 10 hours, and the version that's using a script is running in...
August 15, 2019 at 11:38 pm
This update is primarily for anyone who comes across this in the future, with a similar question.
For my case, Unpivot was slower than the script component, because I was able...
July 29, 2019 at 9:35 pm
Yeah, when I have to work with the long, ugly queries, I usually pop them in to either gVim or SSMS, but it's an extra step, and doesn't change the...
July 15, 2019 at 5:56 pm
Let's just say I'm using this as a learning experience and want to try different ways, even if I end up going back to staging tables in the end.
July 12, 2019 at 9:33 pm
@alphatangowhiskey -- Ah! I missed that one, hiding down at the bottom of the Other Transforms list! Thanks; I'll see if I can get what I need from...
July 12, 2019 at 8:32 pm
I've used it extensively in the past, but we're not currently doing a lot with it, though we may scale back up. The customer support reps were always extremely helpful,...
April 11, 2019 at 11:40 pm
Agree with minimum necessary privileges, but also, in order to avoid accidentally modifying prod instead of dev / test, I find it's useful to use Register Server in SSMS and...
March 11, 2019 at 12:36 pm
March 5, 2019 at 3:19 pm
I like using the convention of calling the -[char], --[keyword] etc switches or options, after...
March 4, 2019 at 4:24 pm
I should unpack that a little more. The fundamental Unix conventions were established in the 1960s and 1970s, when computers were far more limited in CPU, memory, and network bandwidth. ...
March 4, 2019 at 3:44 pm
March 4, 2019 at 2:57 pm
We mostly use schemas for organization, but we do have some per-schema permissions set. This is partly because the DB started in MySQL, and was only recently migrated to SQL...
March 1, 2019 at 12:24 pm