Viewing 15 posts - 1 through 15 (of 120 total)
I am checking on this article right now and will report back
April 9, 2020 at 4:49 pm
10,000 and 10485760 (I think default values). Could this be the issue then?
April 9, 2020 at 4:43 pm
The only transformation I have right now is a data conversion. Is that considered a blocking transformation?
April 9, 2020 at 2:04 pm
I believe the stored procedure implicitly returns the double quotes to capture the field as there are some addresses with commas. What is the best practice in SSIS to handle...
December 3, 2019 at 12:26 pm
Thanks for the reply. I do see that there used to be a connector, but it is not there now. I have a feeling that their new licensing model for...
November 14, 2019 at 11:46 am
Thanks for this useful information. And yes, I just reworked your response and it works fine. And yes, I am a programmer, not a DBA 🙂
June 3, 2019 at 3:05 pm
Thanks Sue. Using NT AUTHORITY\Authenticated Users seems to have worked
December 28, 2018 at 5:25 am
Thanks and I will try it out tomorrow morning
December 27, 2018 at 2:56 pm
Thanks, I will check that out
December 5, 2018 at 11:28 am
So for example, I have a list of Last Name, First Name, MI concatenated with Title (such as PhD, MD, CRNA, etc) and then concatenated again with specialty (like Cardiology,...
December 4, 2018 at 10:26 am
Yep. got it and thanks! Redownloading it brought up the options of components to install.
December 3, 2018 at 12:10 pm
And when I do that through the control panel, the Visual Studio installer comes up and under Data Tools, I do not have the option for Reporting Services.
December 3, 2018 at 11:55 am
It kind of helps, but I only have SSIS there. How do I get the rest of the SSDT features?
December 3, 2018 at 11:24 am
I have been in the IT world on both hardware and software for over 30 years now. Yes, I just turned 51 yesterday and an starting to count the years...
September 7, 2018 at 8:32 am
Yeah, Symplr sent me the data table dictionary and it is pretty massive. We need some licensing reports for our Pharmacy that we are running using the Cactus DB. I...
June 6, 2018 at 6:36 am