Viewing 15 posts - 301 through 315 (of 13,848 total)
Are you editing the SSIS project in VS2022?
Have you set TargetServerVersion to SQL Server 2022 in the project's properties?
Have you taken the 'Upgrade All Packages' option to make sure they're...
August 30, 2024 at 10:49 am
There might be some fair overhead to getting the current length of a text column. If you really have to have that, add a column to the table to...
August 30, 2024 at 9:13 am
Is this a blog post, or do you have a question?
August 29, 2024 at 4:11 pm
Comments posted to this topic are about the item GIT Configuration and Automated Release for Azure Data Factory, which is is not currently available on the site.
It's available to...
August 29, 2024 at 9:16 am
Drew's suggestion is the way forward. Here is an article which demonstrates the technique:
https://www.sqlservercentral.com/articles/the-output-clause-for-update-statements
August 28, 2024 at 2:17 pm
I ran into this issue using dbatools
WARNING: [09:31:34][Get-DbaDatabase] Failure | The certificate chain was issued by an authority that is not trusted
Set Trust Server Certificate to true to jump...
August 27, 2024 at 1:43 pm
thx phil, its tempting but then i have to wonder why the bogus pkg has no problems connecting to a different server from the vm using native.
True, I think...
August 27, 2024 at 12:58 pm
thx phil, its tempting but then i have to wonder why the bogus pkg has no problems connecting to a different server from the vm using native.
True, I think...
August 27, 2024 at 12:56 pm
When I connect to 2022 databases on an Azure VM, I use the MSOLEDB provider, because I had trouble connecting with Native Client. Maybe you could try that.
August 26, 2024 at 8:16 pm
When you say 'the catalog is there', what do you mean? SSISDB is the catalogue. The action of creating the catalog creates SSISDB.
August 21, 2024 at 3:54 pm
First of all you talk of having no Id or password, but then you all about updating a password. Which one is it?
August 20, 2024 at 7:11 pm
That is what I was suggesting. I also use SSISDB environment variables to override environment-specific items. But if the settings are the same regardless of environment (eg, the name of...
August 14, 2024 at 2:47 pm
Not quite what I asked, but good enough!
I'm wondering why the source of that message is 'Transact SQL Stored Procedure' and not from the connection manager, but I'm not sure...
August 14, 2024 at 2:18 pm
I tried that...
now I receive this error....
Invoke-Sqlcmd : Cannot open database "DB" requested by the login. The login failed. Login failed for user 'Domain\User'.
Seems like a reasonable error message...
August 14, 2024 at 10:12 am
Viewing 15 posts - 301 through 315 (of 13,848 total)