Viewing 15 posts - 1 through 15 (of 27 total)
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
Many thanks for the recommendation!
January 21, 2015 at 7:26 am
Many thanks for the response
November 5, 2014 at 10:19 am
The conditional split was exactly what was needed. I placed a rule/filter in the conditional split to only export rows that had a 9-digit social security number into the...
August 25, 2014 at 8:29 am