Thank you very much for the insight.

Most of the queries are straightforward "Select Col1, Col2, Col3 from Table" in nature. There are, however, several of the SSIS pkgs that have...

Everything date-wise with the 4 date columns I'm dealing with in SQL Server, which match-up with the exact-named 4 date columns in Oracle, are coming together in a Merge Join...

Thanks... I'll check out those links right now and will post back on here if they prove helpful.  Appreciate it!

When you mention "Oracle Client", that's different to me than "Oracle ODAC". Or maybe that differing terminology is actually referring to exactly the same thing. Can you clarify this when...

Thank you again for the continued expertise-sharing!

I have no idea on the still-old version of SQL Server. I'm not involved with any of the decisions on upgrades/etc. We are about...

Thank you for engaging this post and for your input. I will try to answer your couple of additional questions.

The Oracle table used to be updated from the master data...

Turns out SQL Server didn't like the fact that i was making a small edit to the DTSX file in Notepad++. I went back to the development environment and made...

Thanks for the suggestions, Andy. That's what I'll have to shoot for if we can't get the issues resolved as they stand at present... writing some very simplistic pkgs....

The SQL Server Agent Jobs weren't modified in any way, and they're still set as they were previously to run in 32-bit mode.

Appreciate your suggestion though.

The initial stored procedure uses several Views and Functions that are complex and time-consuming to run. This stored procedure as it stands at present runs approximately 500 times (once...

Update here:

This might be a good article... just found it, but I'm still appreciative of anything else someone might be able to push along info-wise if you've accomplished this successfully.

Thanks...

That's awesome if that's the case. I'll try this out this evening. Many thanks again for the info!

Many thanks for both of your replies & opinions. I just didn't want to look past a simpler solution that I wasn't thinking of and overcomplicate things w/SSIS for...

Thank u 4 the recommendations. I'll try your suggestions, or I'd possibly come up with the idea of using a conditional transformation to get those records meeting the Rehire Date...

I'm assuming you mean by "connectors", in my example, possibly the Microsoft Access Database Engine 2010 Redistributable? My SSIS packages deal exclusively with importing lots of Excel files and...