I found this powershell script

https://docs.certifytheweb.com/docs/script-hooks#example-update-sql-server-reporting-services

"Is there a way to change the lock timeout in System_Health GUI? In the u_table.sql it looks like it's seto to 30 seconds now. Our jdbc connections are set to...

So system health is not reporting anything because the timeout is set to 30 and in the code of u_tables.sql at line 187 (at least on mine):

(duration > 30000 --...

Right mouse click on System_Health and go to Properties.  It will load this GUI screen:

I switched to just Open with all the parameters and it's working now.

Data view helped, I never tried to get it going before.  It's actually occuring on the data source.  The file definition had char(15) for it and was set to ignore...

Instead of truncating and inserting as truncated, I want it to redirect row to the error output file.

It's not clear why it's truncating.

Thanks.

Thanks, it looks like bids was missing, so  I have unistalled and reinstalled.

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

At least I can add the dtsx now.  I will resume next week.

Thanks!

Sorry, I don't see SSIS Package node underneath projects (see above image).  Maybe something is not installed?  Yet, I have SSIS on the menu when I open a .dtsx and...

Please bear with me.  I've never had to create a project in the 23 years I've worked with SSIS.  I created a SQL Server project and add my .dtsx and...

I've looked all over for the project / package props and cannot find it.  This was originally created with SSIS Export from SQL 2008R2.

Right mouse shows nothing...

• This reply was modified 4 years, 10 months ago by  Sailor.

I wonder if companies are starting to think that we are all brains and that we should just google search our way out of problems.  Hey, google knows everything (or...

Ahh, yes the table does have a full text definition.  It's just not finding   A00J010002158.  If I do like '%A00J010002158', it finds it.  But that is very slow.