Great article and something I never thought about doing. I think you might have shaved about 20 minutes off my average time to create a source from scratch.
Thank you.

having passed a half century of living a few years back, the visual issues with screens, and UI design is definitely a bit of a problem, especially when it comes...

True, but if you are trying inside the code to know or identify which is which by properties, methods, etc. the option doesn't exist yet.

I have noticed that the problem occurs more often
a) the script task is written in VB
b) the script task has additional imports of libraries.
c) web service references...

Makes sense. Thanks!

Mostly I want to know for personal education and understanding, but it seems to me, that knowing what variables were provided outsite the task could improve re-usability by allowing the task and...

I've experienced a similar thing in VS2015 when opening packages originally created/modified in VS2013. Its complicated a bit by our using the PragmaticWorks BIxPress monitoring and auditing frameworks. However, once...

Clearly I have a lot more to learn about CTE's, among other things.

wups! Sorry. SQL Server going from 2014 to 2016, and Visual Studio going from VS13 to VS15.

Thanks.

I never thought about applying if I think I can handle 50% of what they describe. That is advice well worth remembering and I thank you.

Mostly I tell...

when working, I prefer lighter backgrounds and dark text. With my age and eyesight, it gives me the best visual contrast. But, when working on a presentation, here's something I was taught...

Both CLI and GUI have their advantages and disadvantages. I'd like to believe I'm in the majority of rational thinkers in that, where a CLI is more efficient or provides an...

PL/C (supposedly the Classroom version of PL/I), Fortran, PDP-11 BASIC-PLUS, PDP-11 Assembler, APL, Pascal, LISP, FORTRAN, then a stint with SAS (college and grad school are great places to play...

Hi Tim,

The failures are a bit out of my control. Its a third party Upsert Data Flow task. I suspect that every now and then, it hiccups and forgets to...

to answer the question, there is a changelog table associated with each table that has the changedate and a calculated modification number, so the initial extract is all records in...