Monthly Archives: October 2021

TCC

TCC – Dead Man Walking (So long and thanks for all the fish…)

October 12, 2021 – 9:00 pm

So word came down through the grapevine that Taleo is no longer being sold by Oracle and the end of life has been set at 4 years, I guess that would be 2025. It’s funny to think back and I’ve been dealing with Taleo in one form or another since 2007, the last 14 years, and just over a quarter of that time it will cease to exist.

Super annoying considering I was planning on doing the TCC thing into retirement but no biggie, there’s bigger and better fish to fry hopefully outside the Oracle sphere of products. Candidly I’m thinking of Workday but I’ve peaked behind the curtain of the ATS portion of the product and it’s a little scary that it’s that convoluted and disoriented. I’m wondering if the decision in 2013 to stick with Taleo vs SalesForce was right, although I can’t be sure, my path is set by a higher order and I’m here to learn and enjoy the ride. Looking forward to what’s around the next bend!

Permalink | Comments Off on TCC – Dead Man Walking (So long and thanks for all the fish…)
SSIS

SSIS – ForEach looping import files

October 12, 2021 – 2:30 pm

One of the harder things to learn in SSIS is the looping through files and importing them into the DB to be able to work with them. Almost all integrations produce files as [what I am]-[datetime].csv. For example recruiting-Application_Attachments-20211012 00558 is the manifest file extracting the recruiting application attachments and the time-date at the back let’s us know when.

Hopefully the export can take place using one file but don’t count on it, you have to apply looping throughout the whole process, from whatever is doing the extract, through the transfer and onto the load. So if you have a dozen files like above (or 100, 1000, 10000) you need to loop through and transfer.

This walk through from stack overflow is dead on and should get you started in the right direction.

Permalink | Comments Off on SSIS – ForEach looping import files