Jeff Moden wrote:
I only get that error occasionally. It may have to do with whether or not someone posted while you were typing or waiting.
Ok... just remembered who I'm talking to so I apologize for that micro-lecture... You know the old drill, Rick... you're older than I am (I think). 😀
Hey, Jeff, lecture away. I just thought maybe it was me.
Yeah, I'm the old guy, maybe the oldest active on here. I'll be hitting 79 next month. Any of you guys beyond that?
And I'm still actively writing code and learning SSIS for myself all the time. Doing DOS batch command files that call two commercial applications to export 78 years of historical data, things my Dad started for me, from 40 archive files for import to my own database. Today knocked out two FOR EACH containers to find and process certain files in a directory. Also just did an 9 page SQL process that does multiple update queries on a temp table of 1.3 million rows of text data, using nested text function calls in about eight updates to subsets of the data to identify, clean and prep the data for parsing into relational tables. And the cleaning-formatting all happens in less than 30 seconds. Just got to love that SQL and SSIS.
And now it's merlot time with my sweetheart.
One of the best days of my IT career was the day I told my boss if the problem was so simple he should go fix it himself.