Upgrade SQL Server 2016 to 2019
Is there any known issues in upgrading from SQL Server 2016 to 2019? Can it be done by a SQL novice or do you need to have more knowledge to perform the upgrade? We currently are using Microsoft SQL Server 2016 (SP2-CU12) (KB4536648) - 13.0.5698.0 (X64) Feb 15 2020 01:47:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor) Thank you for any suggestions or help you can provide.
How to get last updated date of the table
Hello Experts, I am looking for the date, when is the last update (delete, truncate and reinsert) was made on the table I came across SYS.DM_DB_INDEX_USAGE_STATS table with LAST_USER_UPDATE column, but sometime it returns NULL, Shall I believe on it gives me what I am looking for Regards, Amitdate data type to a datetime data type resulted in an out-of-range value
I've a 3rd party reporting software using SQL as the database. During ETL, I saw this error: "System.Exception: "The statement has been terminated.". Description: The conversion of a date data type to a datetime data type resulted in an out-of-range value." Is there any adjustment require at SQL?
SSIS Performance issue uisng Oracle 19c client
Hi, My SSIS package takes around 20+ minutes with Oralce 19c client. The same package was taking around 4 min. with 12.1. Earlier to I noticed issue with 12.2 and saw that is know bug - OraOLEDB 12.2, which has memory issue ( https://support.oracle.com/knowledge/Oracle%20Database%20Products/2579259_1.html#FIX) . Please anybody face similar isuse? ThanksNew-Object : Cannot find type [System.Data.SqlClient.SqlSqlConnection]:
Firstly, not sure if this is the correct forum so suggest the alternative, if it isn't Anyway, I am working with a client and I am seeing a strange issue that suggests a SQL user account does not have the correct permissions to execute a stored procedure on a on-prem SQL Server 2019 server. When I look on SSMS then it all looks ok. So on a SQLServer 2019 VM on the network I tried to run the following commands in PowerShell 7.3 session [Reflection.Assembly]::LoadWithPartialName('System.Data.SQlClient') # this gets me 22.0.30-preview ( note couldn't seem to install this in Windows PowerShell 5.1, so I switched sessions to 7.3) Install-Module -Name SqlServer -AllowPrerelease -Repository PSGallery -Force $Server = "myserver.mydomainlocal" $Database = "MyDatabase" $User = "domain\myaccount" $Password = "12345678" $SqlSqlConn = New-Object System.Data.SqlClient.SqlSqlConnection("Server = $Server; Database = $Database; Integrated Security = False; User=$User; Password=$Password") $SqlConn.Open() New-Object : Cannot find type [System.Data.SqlClient.SqlSqlConnection]: verify that the assembly containing this type is loaded. At line:5 char:15 + ... qlSqlConn = New-Object System.Data.SqlClient.SqlSqlConnection("Server ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidType: (:) [New-Object], PSArgumentException + FullyQualifiedErrorId : TypeNotFound,Microsoft.PowerShell.Commands.NewObjectCommand You cannot call a method on a null-valued expression. At line:6 char:1 + $SqlConn.Open() + ~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull Looks like I am missing a module or assembly. Does anyone know what this is?
Cannot do an offline install of SSDT for VS 2019
I was told by Microsoft https://visualstudio.microsoft.com/vs/support/#talktous that it is not possible to do an offline install of the SSIS extension for VS 2019. It was possible for VS 2017, but the --layout parameter in the current Microsoft.DataTools.IntegrationServices.exe 15.0.2000.167 no longer does anything. We wish to create an offline install so that we can nail down exactly what will be installed. Is this possible?You can now skip SSIS package validation (new setting in SSIS extension 3.9)
With the new version of the SSIS extensions (v3.9), you can set an option to skip the validation of SSIS packages during opening. I've collected the information in a blog post: https://workingondata.wordpress.com/2020/08/24/how-to-skip-ssis-package-validation-new-in-ssis-extension-v3-9/ Have fun and faster SSIS development for you! 😉 WolfgangSSIS Excel Connection Manager error
I'm having issues with excel destination in my SSIS package. I'm using a conditional split to send data to a spread sheet from OLE DB source. I feel the issue is because of the version of excel SSIS allows to choose in the connection manager window. I could be wrong. Other destinations like flat file or OLE DB are not giving issues. I recently upgraded Microsoft Office 365. Screen shots of error included here. Thank you for your help in advance.
