We do not have Query Store as the SQL version still being used is 2012 sadly.  Would there be any other way to do it?  I am by far a...

As for downloading a report in Power BI, I have been able to download both in Excel and PowerPoint including PDF.  I think my management likes Power BI better because...

Thanks and you bring up some great points.  I might do a script component with some regex.  And because of how this data is being input and there are not...

Thanks for the replies.  I wish we could change the application, however it is a vendor we prefer not to deal with too much.  I will try all of these...

I am checking on this article right now and will report back

10,000 and 10485760 (I think default values).  Could this be the issue then?

The only transformation I have right now is a data conversion.  Is that considered a blocking transformation?

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...

• This reply was modified 4 years, 11 months ago by  Brad Allison.

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...

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 🙂

• This reply was modified 5 years, 5 months ago by  Brad Allison.

Thanks Sue.  Using NT AUTHORITY\Authenticated Users seems to have worked

Brad

Thanks and I will try it out tomorrow morning

Thanks, I will check that out

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,...

Yep. got it and thanks!  Redownloading it brought up the options of components to install.