Viewing 15 posts - 1 through 15 (of 30 total)
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...
June 19, 2020 at 4:58 pm
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...
June 9, 2020 at 11:25 pm
Thanks... I'll check out those links right now and will post back on here if they prove helpful. Appreciate it!
June 6, 2020 at 12:41 am
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...
April 18, 2019 at 1:32 pm
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...
April 7, 2019 at 8:51 pm
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...
April 7, 2019 at 12:34 am
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...
January 5, 2018 at 5:04 pm
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....
August 1, 2016 at 8:51 am
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.
July 31, 2016 at 7:04 pm
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...
December 28, 2015 at 7:40 am
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.
March 7, 2015 at 9:15 am
That's awesome if that's the case. I'll try this out this evening. Many thanks again for the info!
March 6, 2015 at 5:18 pm
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...
March 2, 2015 at 12:20 pm
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...
February 7, 2015 at 1:53 pm
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...
January 21, 2015 at 12:46 pm