Still no notification emails - at least I have not received any.

If you include the column in the insert and don't specify the default keyword - then the value will be inserted as you sent it. That is - if...

• This reply was modified 3 years, 10 months ago by Jeffrey Williams. Reason: BBCode comment
• This reply was modified 3 years, 10 months ago by Jeffrey Williams.

Personally, I'm not a huge fan of that "fix". My approach would be to change the SQL Server Service and SQL Agent Service to run as an AD...

Just for your own sake - every script that you run should be saved in the file system, preferably a shared location. Include identifying information in the file name,...

I tried both Edge and Chrome - no luck. Missing the menu items - assume there was a recent update?

My guess is that it is probably some type of Julian date - having the year (first 4 digits) and day of year.  If that is the case - then...

• This reply was modified 3 years, 10 months ago by Jeffrey Williams.
• This reply was modified 3 years, 10 months ago by Jeffrey Williams.
• This reply was modified 3 years, 10 months ago by Jeffrey Williams.

Before going much further - you need to understand the issues with .AddWithValue.  There are some serious drawbacks to using that - and it will cause you issues that are...

You can pull down the project into VS using the 'Integration Services Import Project Wizard'.  This will prompt you for the server where the IS catalog is located and then...

I would add a check in the agent job - and then schedule the agent job to run every xx time.  The check looks at the table - if the...

How are you identifying the issue as disk IO latency?  This is important - because most tend to look at the wrong counters when working with SQL Server to determine...

Here is one article I found: https://www.sisense.com/blog/spline-interpolation-in-sql/

Not sure if that is the most efficient though.  It might be more efficient to create the function in Python - and call that...

I would review that query - it is forcing a MERGE join which may not be the best option now for those temp tables.  You should also review how those...

Neither method is going to be any faster - the code is updating every row in the table ExtractReports.dbo.FinalComplanceDataDelivery.  If you want to improve performance, or more likely - reduce...

Yes - I understood your question.  There is a difference between the name of a textbox - and the column name coming from the dataset.  In your tablix - right-click...

Not sure I follow why you are doing this - you stated you are trying to automate what columns to include in a view?

Why would that even matter?  If the...